syncing with my accounting software requires separate tables for customers and vendors.
I am modifying my existing DB to reduce double data entry.
in my industry, there is a lot of mixing of customers, vendors, who are either contacts or companies. I have 2 options that I have some with to convert to that will allow the flexibility I need but I cannot decide on which I prefer. right now I have a contacts and companies table. I would make one to one relationships to create a customer and/or vendor record from a contact or company. I would have to maintain customer and vendor data on the contacts and company layouts separately.
on the other hand, contacts and companies are both entities that I do business with and there is no reason I cannot relate them to other records in the same table. In fact, it would allow more flexible relationships. for example this company is the rep firm for this manufacturer. I know I could achieve this in the 2 table method as well but it would be more complicated interface IMO. But all customer and vendor data would be displayed in a single layout.
I have inserted sample graph images of how I would work my 2 options. Thanks in advance for your input!