How can i achieve the following:
From two tables, 1 by the name of invoices and 1 by the name of payments.
I want to show on a single form line by line the following.
Date |Payee/Payer| Ref (either chq/Invoice No|Net |Vat|Gross |Type
01/03/04 Me 101010 10.00 1.75 11.75 Chq
02/03/04 Them R210011 11.00 0.00 11.00 Inv
Etc
Could have a dozen invoices and 1 payment. Iv'e never tried to do this as ive never had the time. i usually just create a multi form with payments & invoices seperated.
In the invoice table the date field would be name InvoiceDate
and in the payment table PaymentDate
From two tables, 1 by the name of invoices and 1 by the name of payments.
I want to show on a single form line by line the following.
Date |Payee/Payer| Ref (either chq/Invoice No|Net |Vat|Gross |Type
01/03/04 Me 101010 10.00 1.75 11.75 Chq
02/03/04 Them R210011 11.00 0.00 11.00 Inv
Etc
Could have a dozen invoices and 1 payment. Iv'e never tried to do this as ive never had the time. i usually just create a multi form with payments & invoices seperated.
In the invoice table the date field would be name InvoiceDate
and in the payment table PaymentDate
Last edited:
