Multiple Invoices Layout)

[ronnie524]

I am a bit in trouble in solving this.

I have three type of invoice layouts- one for international ,one for US Customers, onve for multiple stores (multiple packing slips and single invoice); and one for international customer

I currently have all layouts in Exel.

Invoice 1: (US Customer)-just a regular commrecial invoice

Invoice 2: (Multiple stores)- 1 single invoice with multiple stores/ and different quantities of product for each of them

Invoice 3: (Overseas)- Almost same info like "Invoice 1" but has additional fields.

THanks in advancee

[Vaughan]

And your question is....?

[ronnie524]

Would you make separate 3separate invoice database and relate to the products/ customers or should I put in the same database with many fields where I am not gonna use many of the fields for some of my customers? Reason asking it is that even if I use 3 separate invoicing, how would I link them back together?

[RalphL]

I would consider 1 invoice table that has all the common fields and 2 or 3 sub-tables that contain the fields unique to the different types. These would be a 1 to 1 relationship.