auto numbering

[ferhanz]

Hello All,

How can i create a customized auto number field for table Order in ms acess if i already have a id field with Auto Number as type.

example

id (auto number) ---- order_id (custimize auto number)---- order_detail
1 100023 Pizza
2 100024 Burger


I hope the above table makes sense

Farhan

 

[Chrisopia]

I too am looking into this sort of process, I have been told to look into the DMax function.... in which I am currently trying to figure out.