Multiple Records in Tables

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have four tables that each contain a unique account number for a customer
and a service rendered. I want to be able to query out the various
combinations of who had what done.

Example one table has an account # and tire rotation. The next table has
account # and oil change. The next tune-up and the next air filter.

I would like to query who had just a tire rotation, who had a tire rotation
and oil change, who had a oil change and air filter and so forth.

Any help is greatly appreciated and thank you in advance.

Tim
 
Do not use separate tables but just add a field identifying maintenance action.
AccountID -
Customer - Text
SvcType - Text - Oil Add, Oil Change, Tire Rotate, Fix Flat, Tire Balance,
etc.
SvcDate DateTime
 
Back
Top