Creating Secondary Subform

[daltman1967]

I'm trying to create a database. The main table is customers. The secondary table is vehicles. This is a simple one-to-many relationship. However, for each 1 vehicle, there is a tertiary table called payments, which is ALSO a one-to-many relationship.



What I want is either all on two separate forms: #1 the customer I'm looking at, #2 the vehicle list for that customer, with associated payment for THAT VEHICLE ONLY. As you cycle down the list of vehicles, the list of payments will be changing accordingly. I've got the first part - the customer & vehicles - but can't figure out how to get the tertiary table to display properly. All it does at the moment is display ALL records.

Can anyone help??

[ranman256]

The 2nd sub form (payments) would have the property LINK MASTER FIELDS to the carID.
(car ID picked in sub)
It would be the item picked in the 1st subForm... forms!frmMain!form!subFrmCar!txtCarID

[daltman1967]

Wow. Thanks. However: How do I get it to update when I change records on the vehicle?

[daltman1967]

Never mind. I got it. Thanks for your help.