D
DS
I have a Database with Sales.
The problem I have is how do I set Up the Payments, etc., ?
Heres what I have
Sales Table Sales ID#, Date, Employee
Sales Detail Table Sales ID#, Product ID#
I need to add Payments, (Note Several Payments can be applied to a Sale,
Visa, Cash, Amex, MC etc.
Then I have Discounts, Coupons, Overings, Refunds.
Each one of these can be applied to both the item in Sales Detail, or on
the entire Sales itself
Then each Discount, Coupon, Overing and Refund have a dfferent type to
them. Also once again, several of each can be applied.
I have a table for each of these:
Payment Types
Discount Types
Overing Types
Coupon Types
Refund Types
Do I need more tables?
Thanks for any help in sorting out this mess.
DS
The problem I have is how do I set Up the Payments, etc., ?
Heres what I have
Sales Table Sales ID#, Date, Employee
Sales Detail Table Sales ID#, Product ID#
I need to add Payments, (Note Several Payments can be applied to a Sale,
Visa, Cash, Amex, MC etc.
Then I have Discounts, Coupons, Overings, Refunds.
Each one of these can be applied to both the item in Sales Detail, or on
the entire Sales itself
Then each Discount, Coupon, Overing and Refund have a dfferent type to
them. Also once again, several of each can be applied.
I have a table for each of these:
Payment Types
Discount Types
Overing Types
Coupon Types
Refund Types
Do I need more tables?
Thanks for any help in sorting out this mess.
DS