Displaying fields from Multiple Tables

[JulieS]

Hi,

I'm working with a data environment and 3 tables that are all related. I am trying to display the fields so that when the ID in table2 = 002, the foreign key ID in table3 will display all records with ID=002, and increment accordingly (using next buttons).
HOwever, right now all it's displaying is random records and nothing is connected. How would I begin writing code for this task?

Thanks for any help you can provide,

Julie

 

[peekay]

Try to inner join the tables on the IDkey

PK Odendaal
pko@mweb.co.za