Posted - 04/27/2015 : 10:07:53
| We have customer Types that have different business rules required based by class.
Customer Class Type #1
Customer Class Type #2
Customer Class Type #3
In the example above, both the SupplierCustomerID# and the payToCustomerID numbers are referring back to the Customers Table. In order to get information about the Pay To Customer, a query to the Customer table is needed.
What is the best practice for handling this type of database design?
Thank you for your help regarding this database design question.
Edited by - buckeyeJane on 04/27/2015 10:55:56