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..
any idea is welcome.