autofill question

[steely via AccessMonster.com]

I currently have one table (table 1) that I created with a primary key
(Site ID) and several fields that I would like to have autofilled into
another table (table 2). Table 2 has a number of fields that I would like
to have entered manually as well as the fields to be autofilled. A number
of records have been entered into table 2 already but I would like new
records in this table to be autofilled. I have created the autofill query
but the majority of my records on the form with the control source to the
autofill query are blank for the fields to be autofilled. However, some
were autofilled. Any ideas why this may be and suggestions to fix this
problem. I can give more specifics if necessary.

Thanks.

Steely

 

[Rick B]

Not sure I understand. Why do you want to "autofill data" in the new table?
What are you filling? This is not normalized database design. What if the
data changes? You want to go back and up date all the existing records?

Assuming you have a SiteID and you want to store information about the SITE,
you would simply store the SITEID in your second table and build a link
(relationship) to the Site table. For example, if you are trying to store
the "site name" in your table2, then that would violate normal erlational
database design rules. You would be storing the same site name ten, twenty,
or maybe hundreds or thousands of times in your table2. Instead, you would
store the name and id in table one and ONLY the id in table2. Then you can
pull data from both tables in your queries, reports, and forms if you need
to display or print the site name.

Post more details if you need a more detailed answer, or if this does not
fit your situation.

 

[steely via AccessMonster.com]

Maybe I misspoke.....basically what I am trying to do is use a form to
enter data from four different surveys. I have created one table with site
information that will not change amongst the surveys. For instance,
section, distance, northing, and easting, etc.... This table includes a
SiteID as the primary key and I have related this table to another table
that has all of the specifics of each survey (water clarity, weather, etc..)
which will change amongst surveys. For each SiteID I have information from
four different surveys. What I would like to do is once I have entered all
of the site information into one form (& stored in a table) I would like
for it to be autofilled into another form where the site specific data is
being entered. So, basically for every new record I would like to type in
the SiteID and have all of my site information autofill into this form. I
would then type in the site specifics into the other fields. I assume all
of this information would then be stored into the query table. One of my
issues is do I use the same control source for both the combo box with my
SiteId (primary key) and also for the rest of the form? This may be why
some of my fields are not being autofilled in my form. Also, do you think I
might be having a problem because I have multiple entries for every SiteID
and may need to have an autonumber to fix this problem?