G
Guest
I am trying to set up a form with different tabs. I want to know how to use
information from more than one table for each tab.
information from more than one table for each tab.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
Just pull the various tables to the query (your form should be based on a
query) and then put the desired fields on the desired tabs.
query) and then put the desired fields on the desired tabs.
G
Guest
In your query, be careful not to include a primary key from the "one" side of
a one-to-many relationship. Instead include the corresponding foreign key
from the many side. This is one of the more common reasons that renders the
query "non-updateable", meaning you can't edit the recordset.
To test the query, execute it and try to change some data. If you can do
it, then you can use the query as a RecordSource for your form. Otherwise,
you'll have to alter the query to make it "updateable". Google
"non-updateable queries" for a more complete discussion of what reasons can
cause this problem.
Hope that helps.
Sprinks
a one-to-many relationship. Instead include the corresponding foreign key
from the many side. This is one of the more common reasons that renders the
query "non-updateable", meaning you can't edit the recordset.
To test the query, execute it and try to change some data. If you can do
it, then you can use the query as a RecordSource for your form. Otherwise,
you'll have to alter the query to make it "updateable". Google
"non-updateable queries" for a more complete discussion of what reasons can
cause this problem.
Hope that helps.
Sprinks