prabha_friend
Prabhakaran Karuppaih
- Local time
- Today, 22:09
- Joined
- Mar 22, 2009
- Messages
- 777
All of the following Bills has to be paid:
1.Purchase Bills (Purchase Table)
2.Sales Bills (Sales Table)
3.Expense Bills (Expense Table)
So the Payment table is having the following fields:
So. My Question here is Which is the right way to get these bills paid?
Kindly share your opinion... Thank you for reading
1.Purchase Bills (Purchase Table)
2.Sales Bills (Sales Table)
3.Expense Bills (Expense Table)
So the Payment table is having the following fields:
- ID (Autonumber)
- Date_Time
- Paid_For (Combo box having "Purchase", "Sales" and "Expense" as list values)
- Ref_No (Purchase_ID or Sales_ID or Expense_ID)
- Mode ("Cash","Cheque","Online")
- Amount
- CloseBillOnThisPayment (Boolean)
So. My Question here is Which is the right way to get these bills paid?
- By Creating individual tables like Purchase_Payments, Sales_Payments and Expense_Payments?
or - The above design is OK?
Kindly share your opinion... Thank you for reading