creating tables for seating database

[ChipF]

How do you set up the tables and relationships (primary keys) to a database that houses seating data for each day of the week. The seat # will be unique, however, each seat will have multiple data for all 7 days of the week, such as employee, type, function, occupied from/to, etc. What we need is a form that shows a certain seat with all the information for each day of the week (not date, just day like Friday). Any help is appreciated.

 

[johnnymac43]

This is the same question, from the same user,as thread181-497843 in the Access other topics forum.

Not appreciated!