Good day all. I apologize firstly as I am a novice to Access. I have dabbled in it in the past, but never retained much nor actively used it for a real world application.
However, I am attempting to create a customer database and I KNOW access has the capability as a solution, I just haven't been able to find a starting point.
I am looking for assistance in either pulling a template and customizing or building based on some guidance.
My organizational issue is as follows:
I have multiple customers and who have multiple assets that carry various equipment. The various equipment is the smallest of the variable sets.
The dataset I have is as follows:
Asset - 1
- Owner
- Operator
- Manager
- Equipment
- A
- B
- C
- D
Asset - 2
- Owner
- Operator
- Manager
- Equipment
- B
- C
An owner can be associated with multiple Assets but also be an operator/manager of multiple assets.
Same goes for an operator and Manager; multiple assets and cross association
What I would like do is be able to query any variable and pull a list of associated with with it.
Ex. All assets with equipment B
or All assets associated with Operator X
I am sure I have seen a template similar to what I am describing but I am unable to locate it nor do I have the skill to create from scratch.
Any assistance would be greatly appreciated!