Can I use customers and Suppliers in the one table system?

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I am rationalizing my business database to incorporate all addresses
(customer, supplier, reps, contractors, personal, freight etc) into the one
table system.

Given this, is it possible to do the same with the
Customer/Supplier system, so having only one Invoice form and using it for
customers (invoices) and Suppliers (purchase orders) and using a filter to
restrict which address name is selected?

I cannot foresee any problem but I
would like to know of any. Please help, Frank
 
one problem will come up when you try to link an invoice to a purchase order
and they both exist in the same table. Having a table refer to itself can be
complicated by the link table required. You're breaking a relationship rule and
there is always a consequence. Don't do it!
 
Back
Top