trying to pull invoice number from another table

[dcman]

Hi I am new to access and I have create a system for a non profit org.

I have 3 tables invoice, customer and items. I need to create a query that will get the next invoice number from the invoice table and mark that invoice number in the items table for a set customer where the invoice field in the items table is blank.

The invoice table is now set up as a autonumber, therefore I need to append to get the last new number.

The items in the item table are unique and this is why I want to mark the invoice number in the item table field invoice.

 

[jdraw]

Although not directly related to your post, I strongly recommend you work through the following tutorial. It will lead you from problem definition to a properly designed database structure with tables and relationships.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Good luck.