How I can make linked query?

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

Guest

Hello

I have 5 tables, 3 of them they have relation one to many grandfather,
father, son and I can see all the Data in one form and when I click in one
filed in the son form it open another form, This form related to another
table, some data (felids) from the son table i need it to be stored with the
data in this 4th table!!!

How I can make query in those condition:
1- Bring the same data from the 1st form and show it in the 2nd form (I use
this function in data source but it is not store in 4th table " =
form!f1!m1").
2- update & store the data in the 4th table after i change it or update it
3- where and how i do it

I hope you get my idea

thanks

khalifa
 
I think that you're mixing together the concepts of linking tables in a
query, with placing data on forms. Seperate them into the pieces that they
are.

When you ask how to 'bring data from the nth form', the answer is typically,
"You don't". You query data in tables based on their ID field, regardless
of how many relationships they have.

As far as 'where' to do things, there are command buttons, double clicks,
and a hundred other event properties that trigger code execution. You just
have to find what will work for you and your users.
 
Back
Top