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,