Multiple Relationships between tables

Question

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 information. I am torn on making these free form fields or relationships. I think a relationship is the right way to go....

So do I create another relationship between Companies and Projects since it is independent of the initial link or should I create a many to many relationship? I think I create multiple relationships... One for the Project to Company primary relationship, another one to many for the bill to and another one to many for the ship to....

Thoughts on that?

------------------------------
Ivan Weiss
------------------------------

MarkShnierYou · Answer

You 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
------------------------------

Sign up

Login to the community