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.