I have a table of companies. I want to create another table of owners. In that owners table I want the list of companies from the compose table. I need to assign who owns different companies. Companies A,B,C are in the companies table. I want the owners table to have a drop down of the companies so they can names owner. Company B owns A; Company C owns B, etc.
Any thoughts.... thanks