I don't have to worry about duplicate data within a record because
each record is for an individual and nothing is duplicated and all the
fields must be entered for each person, so my problem is simple, how
do I get the form so data can be entered into it for all the tables?
RIght now only table 1, my record source is updateable in the form .
I don't see how I can create a query that links every single one of
the fields when there are close to 200 fields altogether.
In summary, I have a primary key in each of the tables and they are
linked in the relationships window, but I can't update more than one
table in the form, what do I do assuming I don't really want a bunch
of embedded subforms or pop-up forms since all the info. is need for
every person entered?
I have the tables linked across each other, do I need to link all the
tables to the same table , table 1?
any help appreciated, at my wits end, thanks