Auto create record in related form ?

[fibayne]

Hi
I have a purchase order and billing DB which when I receive a supplier invoice relating to the purchase order I go to the line on the order it relates to click on a button which takes me to a related form SupplierBilling where I can enter the invoice details. The DB is also 'almost' ! set to produce reports eg supplier activity which looks at all orders on the DB and lists them by supplier, at the moment I can only get it list out those recodrs that have data entered in the related form, SupplierBilling, if there is an order against a supplier but is has not yet had an invoice recorded against it, it will not show on the report, I am creating this report to basically show our liabilities with that supplier.
I have looked and searched on the forum but as of yet not come up with what I think will help me, would anyone have any pointers on how to either auto create a record on the form supplier details or how to get the report to show all records for a supplier whether or not there is a related record in supplier details.

many thanks in advance for any help

 

[fibayne]

Hi Pat

Many thanks for your reply that works perfectly thanks for your help, I am now having a small problem in that if an order has more than one invoice when I sum the totals on the report it sums the value of the order twice or for how ever many invoices are allocated against that order, I am working on the report at the moment but cant seem to make it sum the order value only once

thanks for any more help in advance...cheers

 

[fibayne]

Hi Pat Again many thanks for your reply I will try that and see how I get on..cheers Fi