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