AnsweredAssumed Answered

parent/child company relationship

Question asked by AdamReed on Apr 11, 2011
Latest reply on Apr 11, 2011 by AdamReed


parent/child company relationship



In my database project I have a company table which contains fields like company id, company name, type, address, etc.  I would like to be able to identify some companies as parents or subsidiaries of others.  Currently I've just created another instance of the company table, and am linking "company id" to "parent company id" -- but some strange things are happening (like the id count will be one number higher, or I create duplicate records, etc.).  Could someone walk me through the simplest way to do this?

Thanks very much,