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
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