Aug 23 2004, 07:15 AM
How can I include fields from two tables in a form? I've tried, =tablename!fieldname, but it doesnt work. Is there any way?
Please help me.
Aug 23 2004, 07:18 AM
You could base your form on a query which would include these field's from (2) different tables..?
PS: Table relationship has to be inplace..
Would like a little more detail as to what these fields will do..? (display/update/etc)
Aug 23 2004, 07:54 AM
I have the same problem. I think the answer may be to use subforms for each of the "other" tables. I'm just starting to read up on that subject, so I can't offer much help than to point in that direction, but if I'm wrong, it's a wild goos chase for you.
Aug 23 2004, 07:59 AM
First a tip on using UA (or any site like it). The more you put into a question, the better we can answer it. If you had posted a more detailed explanation of what you are trying to accomplish we could give a more definitive answer. There are several ways to show fields from multiple tables on a form. Use of a multi-table query, subforms and DLookups being the primary ones.
Which method would be best for you will depend on what you want to do with the data and how its related. If you define your needs more we can advise better.
Aug 24 2004, 12:23 PM
I created a query from two tables, which I created relationship, and it worked.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here