Multiple Supplier and Multiple Contacts

[NCD]

If I had multiple suppliers, and within those suppliers i have multiple contacts,

what would be the most appsheet friendly way to make my tables?

[Suvrutt_Gurjar · Accepted solution]

First disclosure: 🙂 This is mostly design approach question, so answer could vary depending on entire app design and requirements. So the suggestion below is purely optional and please evaluate fully at your end before proceeding. 

I would create a parent table of suppliers with contacts as a child table for the suplier table. This assumes that one supplier can have many contacts but any contact can have only one supplier.

[NCD]

Thank you 🙂