L
Lisa Reber
Have been working on this on and off since February and
am ready to tear my hair out! Have the following tables:
Contacts
Vehicles
ContactVehicles
Am working on a fourth table, VehicleRegis.
Have the following form / subform working
Contacts
ContactVehicles link parent/child on ContactID
Vehicles cbo box shows all makes of vehicles
I'm stumped in trying to add another subform for
registration details.
Want to enter date / amount paid and then select vehicle
(s) from the subform ContactVehicles, rather than
tblContactVehicles.
I have the following advice from an earlier post: "For the
details subform, I would not link parent/child fields;
instead, I would filter it by the VehicleID from the
vehicles subform in the vehicles subform current event."
This just isn't getting through to me! How can I filter it?
Long-term usage will be to
1- not have to enter a contacts vehicle(s) every year
2- be able to total registration $ by year or other info
3- be able to list how many Corvettes (vehID), or
trucks (VehType) came to the show (etc)
Any help is appreciated - thanks in advance. - Lisa
am ready to tear my hair out! Have the following tables:
Contacts
Vehicles
ContactVehicles
Am working on a fourth table, VehicleRegis.
Have the following form / subform working
Contacts
ContactVehicles link parent/child on ContactID
Vehicles cbo box shows all makes of vehicles
I'm stumped in trying to add another subform for
registration details.
Want to enter date / amount paid and then select vehicle
(s) from the subform ContactVehicles, rather than
tblContactVehicles.
I have the following advice from an earlier post: "For the
details subform, I would not link parent/child fields;
instead, I would filter it by the VehicleID from the
vehicles subform in the vehicles subform current event."
This just isn't getting through to me! How can I filter it?
Long-term usage will be to
1- not have to enter a contacts vehicle(s) every year
2- be able to total registration $ by year or other info
3- be able to list how many Corvettes (vehID), or
trucks (VehType) came to the show (etc)
Any help is appreciated - thanks in advance. - Lisa