AnsweredAssumed Answered

Dropdown list populated by two different tables

Question asked by Phil_1 on Dec 4, 2013
Latest reply on Dec 5, 2013 by Phil_1


Dropdown list populated by two different tables


     This is two problems with a similar issue.  I'm working on creating a list of notes receivable and the owners of companies.  One table contains individuals with fields similar to a contact list.  The other table contains companies and the necessary fields describing those.  I need to be able to select ownership for each company which can be either a company or an individual.  And, select notes receivable to each of the companies which also can be from either an individual or another company.  I would assume I would need one additional table to contain the notes.  However, I figure the company table would be the best place to store the ownership data.  The question is how to join the tables in order to select the individuals and/or companies during data entry for each of the notes and how to select individuals and/or companies to populate the ownership fields in the company table.

     Thanks in advance.