Help!! eroror with relationship on form

[hullstorage]

Hi all i need urgently if any body can help with the following
i have finally got my customers, invoice and invoice detail to communicate with each other ( finally ).

but what i am trying to do is on my form i have the invoice as the header and the invoice detail subform below
and i am using the dmax funtion to create the invoice number.

the problem i am having is when i select a customer to create another order for them this creates a new invoice number with a new order everytime, but i want it to when i select the customer if they alreay have orders placed to populate the subform with these and use the invoice number already in place then when i select another customer if there are no orders, then create a new invoice number

any help please
thanks
simon

 

[Uncle Gizmo]

I would suggest you have a look at the north wind example database that comes with MS Access, it already has most of the functionality you want I believe.

 

[hullstorage]

thanks for your reply

tried that and got totally confused with the whole setup as my orders are quite different as i do not have products etc..

any other sugestions

this task i thought would be quite simple but this does not look like the case