I am working on a facilities maintenance DB... and I need help

M

Maintenance man

I need some basic level help. I am designing a database that will handle
tagout options for our facility, and the first level will list jobs that need
to be done. When you put in the data for the description of a job, a second
db needs to come up to list the myriad of points where safety lockouts neeed
to be placed.

I have designed the first and the second, but the relationship between the
two seem to be screwed up. Access seems to think there is only one second,
where the first will be a list of an ever growing list of seconds.

What am I doing wrong?
 
K

KARL DEWEY

Create a one-to-many relation between the job and the lockout points. You
need the job identifier in the points table.
 
Top