S
Shawn Repphan
I have 3 tables: Accounts, Services, ServiceTypes.
1. ServiceTypes has a key field and a description field.
2. Accounts has many fields, one being an Account#.
3. Services has a record for each unique Service/Account combination. But
only if the Account uses that service.
My main form displays a record from the Accounts table. I have a subform
displaying the services that account has. I want the services subform to
always display one of each ServiceType record with a checkbox next to it
that is checked only if there is a record in the Service table with that
ServiceType's key and the main form's Account #.
The customer does not want any VB used to make it easier on him to update
the DB. But if there is no other way...
Thanks
1. ServiceTypes has a key field and a description field.
2. Accounts has many fields, one being an Account#.
3. Services has a record for each unique Service/Account combination. But
only if the Account uses that service.
My main form displays a record from the Accounts table. I have a subform
displaying the services that account has. I want the services subform to
always display one of each ServiceType record with a checkbox next to it
that is checked only if there is a record in the Service table with that
ServiceType's key and the main form's Account #.
The customer does not want any VB used to make it easier on him to update
the DB. But if there is no other way...
Thanks