Connecting 4 tables, best solution?
There are 4 tables all interacting with one and other. I will describe them from the bottom up: 1) Documents - this will house all documents that are referenced in the various next 3 tables. The hop...
Forum Discussion
When you want true tracking on a multiple levels you have to create a 'joined table' (for whatever reason, QB people always say 'many-to-many' which is not correct).
So you would need to create the master tables and the joined tables.
...just brainstorming...
You would need the following tables..
Clients
Agreements
Materials/Items
Components
Material /Item Components (Joined table)
Documents
Relationships:
Client --> (has many) Agreements
Client --> Materials
Clients --> Documents
Agreements --> Materials
Agreements --> Documents
Materials --> Material Components
Materials --> Documents
Components --> Material Components
Components --> Documents
Material Components --> Documents
This is just a rough guess based on what you described. Honestly I'd guess you have a lot more moving parts that you are trying to track, so I'm sure we are missing things.
So you would need to create the master tables and the joined tables.
...just brainstorming...
You would need the following tables..
Clients
Agreements
Materials/Items
Components
Material /Item Components (Joined table)
Documents
Relationships:
Client --> (has many) Agreements
Client --> Materials
Clients --> Documents
Agreements --> Materials
Agreements --> Documents
Materials --> Material Components
Materials --> Documents
Components --> Material Components
Components --> Documents
Material Components --> Documents
This is just a rough guess based on what you described. Honestly I'd guess you have a lot more moving parts that you are trying to track, so I'm sure we are missing things.
Thanks, Matthew. You are correct I was guided to utilize a Many to Many, but I find that this is restricted to 2 tables referencing one and other. I'll have to look up more information about a joined table, and how to implement in QB. Any suggestions for literature? Also, in your initial analysis, do you feel my goal is possible without creating a large number of joined tables that feed into larger joined tables?