Query or Table

[finneyz]

Hello all

Not sure if this would be a query or table or whatnot.
This is the breakdown.
I have a PO ORDER no, with a auto number starting at 4000.
That specific customer is ordering the following items

item 1: 5eggs
item 2: 6eggs

I have the items set as auto number, and I need the po as well as auto number
Is it possible to have two auto numbers in the same query. I've tried in several different methods. Union, joins, concatenation.

I am sure this has been asked many times prior. But My aim is to keep both at an auto number state.

the query will then yes, go to a form. Is this possible?
thanks for your advice.

 

[jdraw]

Did you design your tables and relationships before adding data to something?

 

[finneyz]

I appreciate the help and support
I was able to just a query. [purchase_order]+1
thats all I wanted to do.
trying to think too much for a simple increment