How to I Link SubForms?

[georget]

Another Rookie Question...

My forms are built from the tables.
1) My mian form is "Companies" with 2 subforms
2) One subform is "Equipment" Single Form View
3) The other subform is "Financial" Single Form View

"Equipment" is related to the "Company" by DunsNumber
"Financial" is related to the "Equipment" by SerialNumber

If a Company has 5 peices of Equipment, I press next record in the "Equipment" subform to view one record at a time.

I would like the "Financial" subform to advance to the next record when I advance the "Equipment" record.

Please Help...thank you!

 

[pono1]

G,

Assuming you have the Access 2000 Northwind.mdb file on your PC, open the Customer Orders form and take a look at three forms in one (one main, two subs), behaving much like you want your forms to behave. Focus on the Link Master Fields property of the subforms...

Regards,
T