Skip to main content ↑ ↓
Topic: MAKING INVOICES WITH MANY LINES OF PRODUCTS (Read 1952 times) previous topic - next topic

MAKING INVOICES WITH MANY LINES OF PRODUCTS

Hi everybody,
just a dummy question, I try to achieve an invoice generator, with phprad, and i got a problem with the fact that the invoice is technically split between 2 (or more) tables : one for the customer and general invoicing details and another one with the products details which are dynamics (eg insurance contracts )  (the second one bound to the first one by the invoice_id field with many items ) .
explicitely:
INVOICE_ID
MYCUSTOMER_DETAILS ---------MY_CONSUMER_GOODS_1_dynamicaly_made
                                    +--------MY_CONSUMER_GOODS_2 _dynamicaly_made
 
The Add view has to impact the Two tables to create a clean invoice and and I don't know how to manage it with PHPRAD

Thanks a lot for your help