By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,154 Members | 2,313 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,154 IT Pros & Developers. It's quick & easy.

creating a basic, but multi-tabluated form on many tables (15 tables)

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.