AnsweredAssumed Answered

When to Use Field from Related Table

Question asked by NicholasFernandez on Jan 27, 2014
Latest reply on Jan 28, 2014 by philmodjunk


When to Use Field from Related Table



     I am a bit confused as to the best way to utilize related tables. In my database, I have two tables:

     1. Companies we purchase from (each sells many products)

     2. Products from these companies.

     The tables are related by CompanyID. So far, I think I'm doing this properly and everything makes sense.

     But...when I'm making the layout for Products, how/why do I determine whether to use the CompanyID field from the Products or Companies table?

     I want users to be able to create new Companies through the Products layout if that makes a difference. (I have "create records via this relationship" checked.)