db design help

[dandu001]

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.

 

[KarveR]

use sessions, have the agents log in.
from the session , store agent_id in a field within the database so that the orders can be identified depending on who created them.... just an idea

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.