Relationship Logic

[Huddle]

I'm having problems working through the logic of the tables and relationship set ups on this database.

What I am trying to do:
I have Buildings that may have many posts attached to it.
For each post there will be many inspections

I'll have a data entry form where the inspection will be inputted but I need all the underlying connections to run reports. I'd like to have the building number and address show on the form to confirm the post number is being entered correctly, which I thought I could do a subform to show.



It seems I'm making this more complicated than it needs to be.

See the attached.

[orange]

There are a number of models here
http://www.databaseanswers.org/data_models/index.htm

Take a look at the business rules user requirements from a couple of models and create some rules/terms that represent your situation.


What is a Post? Can you tell more details of your requirement.

[Huddle]

Wow that is some site.

A post is a specific area in a building where a security guard is placed. The database is like a quality control on the security guards. We perform random inspections on each post with a weekly and yearly quota that has to be met.