dajoem

Hi there, Is there a way to add an extra column into the item table? For Example, Items table – Current Item Description Tax Value Quantity Last Used A Banana None $8.00 4 31/12/10 B Apple None $15.00 3 31/12/10 C Orange None $10.00 7 31/12/10 D Grape None $12.00 10 31/12/10 Items table – New NEW COLUMN Item Description Tax Value Quantity Last Used Customer A Banana None $8.00 4 31/12/10 John B Apple None $15.00 3 31/12/10 John C Orange None $10.00 7 31/12/10 John D Grape None $12.00 10 31/12/10 John A Banana None $6.00 20 31/12/10 Mary B Apple None $12.00 10 31/12/10 Mary C Orange None $7.00 30 31/12/10 Mary D Grape None $8.00 15 31/12/10 Mary So when i go to create an invoice, selected a customer let say Mary, only Mary's items should be display or allow me to add into the invoice. Why because each buyer will have a set price depends on the volume. If this is allowed, I will buy it. This Express Invoice suits me fine for what I want to do. Looking forward to your help. Regards, David