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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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

Back
Top