General discussion
May 7, 2002 at 01:50 AM
mra2

Access 97 Database Relationship

by mra2 . Updated 24 years, 3 months ago

My propesed database has employees. The Social Security # is unique.

Each employee can work for more than 1 of the 54 shops.

For shop I want to collect the pay amount for each employee.

I might also want a listing for a particular employee to show his total pay for the year from all shops that he worked in.

How do I relate these three tables CORRECTLY????

Thanks for your help!
Alan
NYC

This discussion is locked

All Comments