0

hi people..

I was wondering if u experts could help me with this.
I have attached a screenshot of my form.
This is an invoice system..

I have customers table for customer profiles..
I have Products table
I have manufactures table

I want to save all invoices so that these invoices can be retrieved later for viewing in future.

I just dont know what should be the database structure for this..

it was simple for customers, products and manufacturers...
they had cust_id,prod_id and manufact_id..

shall i create another table called invoices and
probable create invoice_id and primary key, but how do i store these values..coz these will be multiple values in single cell..

please help.
any idea is welcome.

Attachments dialog.JPG 35.3 KB
4
Contributors
5
Replies
10
Views
5 Years
Discussion Span
Last Post by nilesh7136
1

You could create two new tables named Invoice and InvoiceLine. Each invoice would have a unique primary key named Invoice_ID. The fields in this table would contain information relevant to the entire invoice (Customer_ID, date, status, etc). InvoiceLine would have a primary key consisting of Invoice_ID and Line_ID. This table would contain all the info for each invoice item (product id, quantity, unit cost, etc).

Votes + Comments
solved my problem
1

Just make sure you store all the data that are possible to change in the invoices tables, so that you can retrieve the same data as your invoice.
A good example is price, another is customer's info (address might change or whatever).

Votes + Comments
helpful
0

@ Reverend Jim : man u solved my problem .!
I see how invoices work now.

thanks a lot buddy
:)

0

Hey Frnd, Can you give me this project, i have need it for My invoice Generator, i will modify from your project,
Please Send Me At: nilesh7136@gmail.com

Thanks In Adv...

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.