Multiple Relationships between tables
So currently I have a Projects table and a Company table. A company has many projects. I also have an offices table and each Company has many offices. I need to also store billing and shipping info...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou have not actually stated what you goal is, but I assume that you need Office information down on the Project.
I would just make a relationship where 1 Office has Many Projects and make that a Conditional drop down after based on the [Related Company] of the Project.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
I would just make a relationship where 1 Office has Many Projects and make that a Conditional drop down after based on the [Related Company] of the Project.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- Mark,
As mentioned in the first post I need to record the Bill To and Ship to information in the project. This might be different from the Company contact we are dealing with for the project itself.
For example, the project might be Boeing in Renton WA but we might be billing Boeing in Seattle WA. and shipping to Boeing in Renton WA. I need to have those three independent sets of addresses stored
It also could be a project for Boeing in Renton WA, billing JLL in Chicago IL and shipping to Boeing in Renton WA. So multiple combinations are possible
------------------------------
Ivan Weiss
------------------------------- MarkShnier__YouI'm not sure of all the tables and relationships in your app, but basically you will need to have a table of those Bill To Ships to's somewhere. Not sure if that is your "Offices Table". The have a Relationship to look those up down to your Project. Then figure out what you want to use for a Conditional Drop down to only offer up relevant Offices. Any field that you can coax down to the project can be used to filter the conditional drop down.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- Mark, that I get.
The question was should I create "multiple" one to many relationships to the Company table:
One for the Company for which we are performing the project.
One for the Company we are billing for the project
One for the Company we are shipping to for the project (in case it is different from the first)
Or do I need to do a many to many relationship with a joining table in there? I think three one to many relationships are ok but I wanted to confirm before creating that structure
------------------------------
Ivan Weiss
------------------------------
