Below beginner here... I have the information for the database that I want, just can't get it finish

[Dixi23228]

I need help. I have the information all set and in tables. I know what I want, but don't know how to get there. Is there someone that could walk me through it? I have customers that have services through the company. Different customers have services on different products.


Fire Alarm Company....
I want pull up a customer and see what services they have purchased (on one page)
Fire Alarm Inspections
Sprinkler Inspections
Intruder Alert Inspections
Several other types of inspections as well

Month each inspection is due
Number of men per inspection
Number of hours per inspection

Some customers only have fire alarm inspections, some only have sprinkler inspections and some have both.
I have a feeling that I don't have the table set up properly. I am frustrated because I don't know how to get to the end product........ I have tried and tried. Ready to scrap and start over.

[RuralGuy]

How about starting by Googling for MS Access Templates and see if there is one close to what you want. You'll learn a lot by modifying an existing Template as well.

[June7]

Inspection/Maintenance topic of several threads. Start with https://www.accessforums.net/databas...ign-52710.html