Table definition and Relationships

[liamm]

Hi, Im setting up a database to monitor surveys on Emergency Showers. I have the following requirements.
Shower number - unique ID
Shower type - 1 of 3
Location - address
Person doing survey - defined list of names
Date survey was carried out
Comments picked up from survey

Do I create six tables as above?
How would I relate the tables?
Would I create look-ups in the table design?

Sorry if it's a bit easy for you guys but I'm pretty new to Access

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

If you can help, GREAT
If I can help, EVEN BETTER

 

[mikey69]

Probably best to create tables for shower, showertype, surveyor as you suggest and then incorporate lookups into the table, but you don't absolutely have to use tables for source data in each case. You can use list boxes and define the items in the list. The advantage of separate tables is that it makes adding values easy.