DSmith,

I noticed that a field name on one of the tables is a Reserved Word,
tblProcedure - Procedure. This will cause problems for you because it is a
problem for Access. (For a complete list of Reserved Words see...

http://allenbrowne.com/Ap****ueBadWord.html

What I do to avoid this issue is prefix the field names with the table
letters, ie...

tblProcedure
pProcedureID (Primary Key)
pProcedure
etc...

tblLocationObservation
loLocationObservationID
loObservationID
loLocationID
loProcedureID (Foreign Key related to tblProcedure-pProcedureID)
loLocationObservation (Number data Type. 1 = "Safe" and 2 = "At-Risk")

....and so on with the rest of the tables. This should keep your field names
*safe*.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"dsmith via AccessMonster.com" u56186@uwe wrote in message
news:9fc3b1dc79144@uwe...
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