Making a linked subform with two tables

[haavar]

I have to make a linked subform from two tables.
The mainform has data from one table and the child has data from and other table.
I link the ids from the two tables, but its not working. Whats wrong? Can someone help me please?

 

[MStef]

Did you populate a LINK CHILD FIELDS and LINK MASTER FIELDS properties ?

 

[Hoganc]

I had a similar problem the other day, I had a table (query results) which i wanted to display and a notes table which i wanted to update as i looked at the items. (i.e. I wanted to click the query results and go to the relevant notes)
to do this i created a blank form put a text box in the top then used the subform builder to put the query results in the form (creating a subform in datasheet view)
then I put my notes form in using the subform button (p.s. notes was already built but you can do it with the wizard.) then I got got the text box to display the unique id number from the query when I clicked on it - go to control source and use the builder find your form then find the new text box. it should be at the top of the list. then I linked the notes child and master to the child and master in the main form.
hope this helped.
C

 

[haavar]

Did you populate a LINK CHILD FIELDS and LINK MASTER FIELDS properties ?

Yes i did....the ids. But when I go thru the record with the mainform, the subform are not in order

 

[MStef]

In your first mesage you have said
"but it's not working".
Now you say, "not in order".
Be concrete.

 

[haavar]

In your first mesage you have said
"but it's not working".
Now you say, "not in order".
Be concrete.

Sorry, but do you know the answer?

 

[MStef]

I know, but what is the question???

 

[haavar]

The answer was...

I found it out. I had to make a one to many relationship with the tables and then put the subform in combined with the id. Now it works perfectly!

 

[MStef]

My congratulation !