billing software Database

Hi friends,I need the following help in building database with correct way:
I'm building small billing apllication for small business.
I have the following tables:

1. Client table: Holds the clients details

2. Service table: Holds the services kind the business gives (Internet,Cables,Internet and cables ...).

3. Payment table: Holds the payments of the service for each client.

4. Cheque table: Holds the cheques details, if the client pay to the service by cheque.

5. Cash table: Holds the cash mony, if the client pay to the service by cash.

6. Credit card table: Holds the credit card details,if the client pay to the service by credit card.

*. What I have to do on, I mean , how can I link between the payment methods tables (4,5,6) and the payment table 3 ?
*. Which kind of relationship ?

Please help

Best regards
Nikhil

hi nikhil,

make cheque and cash table same,

Add a Payment id on Pay_id

After that insert the Pay_id in Cash/Cheque and Credit Card Table,

Now you can easly track the paymet details from any table,

You can also add the Payment Type in Payment, it's make more easy to track the payment details and more fast also.

Regards
Jitender

__________________
Free Webmaster Tools - Free SEO Tools
phpLDHacks - Add your template or Hack and earn money
Text Link Ads - Buy & Sell text link ads