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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top