Thanks Steve,
I made some progress but I think I've managed to totally confuse myself
concerning table relationships. I will revisit the tips on relationships to
see if I can figure this out.
Steve wrote:
How about the following tables ........

TblProcedure
ProcedureID
Procedure

TblObserver
ObserverID
FirstName
LastName
etc

TblLocation
LocationID
Location

TblObservation
ObservationID
ObservationDate
ObserverID

TblLocationObservation
LocationObservationID
ObservationID
LocationID
ProcedureID
LocationObservation (Number data Type. 1 = "Safe" and 2 = "At-Risk")

Steve


I am trying to create something of a survey database. I have seen the
sample
[quoted text clipped - 45 lines]
I feel comfortable building the forms but not sure of the structure of my
tables and how they relate. Can you help me?

--
Message posted via http://www.accessmonster.com