Informatie of linked tables on one form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have one main table and different other tables witch are linked to each
other. Now I want one form with the information of the tables on it.
Selecting the next record in the main table should update de fields on the
form with the information from the linked tables. But I can't seem to create
the link between the tables/fields on the form. I would expect that this
would go automatically, since the tables are already linked.
I don't want to use subforms, since most relationships between the tables
are one-to-one.

I see a lot of problems in this discussion group that are simalar, but I
didn't find the answer to my question.

Can anyone tell me how to do this?

Greetings,
René
 
How about basing your form on a query which joins all of your tables?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
Update Two Tables Using One Form Contents 0
Using form and subform not connecting to two separate tables 0
Use field to update multiple fields 4
Linking forms based on two fields 1
odd subform which is on the one side of a one to many relationship 6
Prevent Duplicate Form Entries 0
Total Detail on Continuous Form 2

Back
Top