Help please somebody exmample needed

[hullstorage]

i am trying to create the following database and have not really got a clue
this is what i am trying to acheive

i have a few customers that send out deliveries on a daily basis which are invoiced each month so each customer will have say about 20 deliveries per month.

i want to call these records for a given customer which i can do using a query but i am trying to create somekind of invoice table so that when i call these deliveries at the end of the month it will automatically assign an invoice number

i have already created customer table and delivery table but what is the best way round the invoice table, it is probably using relationships but i haven't got a clue about this

can somebody be so kind and email me a sample of somesort
i have looked at northwind but still confused

 

[The_Doc_Man]

This forum has examples posted in many places. If you go to the top level of the site tree, you will see one category above the Access Issues - it is a "Reference" section, and the "Sample Databases" sub-topic is there.

You are doing a shipping and receiving application of some flavor, so search for keyword "Shipping" and "Invoices" in this forum. "Search" is in the menu bar of the web page near the top of the page. Several threads contain sample databases or code snippets that might be helpful.

We rarely handle the kind of request you just made. This forum works best if you have a specific, targeted issue. The "I can't do my job so please do it for me" request rarely gets as much help as you might need. And that is what it appears you are asking.

 

[hullstorage]

hi there thanks for reply

i have done my job because i have been using my own database for 5 years its just the annoying part to get a funtion where i can generate invoice numbers as i have to do this manually by entering the details into the invoice table

any advice

thanks

simon

 

[Rabbie]

Use the DMAX function to find the highest current Invoice number and add1 to it to generate the next one. See Access help for more info.