Table manual modify question -Newbie

M

Mel

Hi
I have a table that contains 7 Number fields as a reference source; I
want to use this table as a base for 52 other tables. The first table
providing standard numbers for the other tables but I want the user to
be able to alter the numbers manually in the second set of tables when
needed. How can this be done?

Mel
 
L

Larry Linson

I don't understand your question. Could you clarify? Do you want to copy a
record from the base table into each of the other tables and then allow the
user to modify what was copied? Is this "on demand" or at some specified
time period, or ???

From "7" and "52", I am suspicious that the first represents something about
each of the 7 days in a week, and that the 52 different tables are for the
weeks in a year. If so, that would indicate to me that you have an
un-normalized design, which will not be efficient either to use or to
develop further.

If the seven Fields represent seven days, then the Field name is serving as
data and that makes life more difficult. If the 52 tables represent weeks,
then it will be quite inconvenient to do a query to get data for the year.

Larry Linson
Microsoft Access MVP
 
Top