Db design help

Hi to all,

I have to make an intranet applicationforthe company I work for. Actually we have 2 stores in wich the customers come and make orders for several products. After one of our agentsenter the order in database he call the supplier to find the prices for the products requested by client. When the agent knows the prices at we are buying, he must enter them in the db and send the offer to the client (with our prices). After the client receives the offer he tells us if he's satisfied with the prices and we buy the products for him.
This is the main idea for ths application. My biggest problem is the db design. Theproblem appears when2 or more agents enter orders in db at the same time. I don't know how to separate order 1 entered by agent x, by order 2 entered at the same time by agent y.
Sorry about my poor english. If youdon't understand what I explained above, please let me know.
Hope someone can give me a hand.

You should have an auto_increment field named id which should be of type int and should be the primary key: int auto_increment primary key
This means that each order will have a unique number that is automatticly incremented from the last entered number in the db. So the first records id is automatically 1 the next 2 and so on.