How to search EOF

[suzie]

I have design a form using FrontPage. There's a field
named Order_Id which generate Order_Id for every entry.
This Order_Id is auto generated by system by checking the
EOF or every Order_Id.
How am i going to do this?what is the code/programming for
checking EOF?
Please help.

 

[Peter Aitken]

I have design a form using FrontPage. There's a field
named Order_Id which generate Order_Id for every entry.
This Order_Id is auto generated by system by checking the
EOF or every Order_Id.
How am i going to do this?what is the code/programming for
checking EOF?
Please help.

Do you want an OrderID value that is different for every order? It is best
by far to design the database so the table has a unique index autoincrement
field. THen it will be done automaticlaly for you.