Hello,
I need your help. What I have is several tables but the problem I have now is:
I have a table in which I save (via a form) the offers we made to customers. What I want to do now is when a customer approves an offer to select this specific order and then save it into a different table called "confirmed orders". I don't seem to be able to figure out what to do. I tried making a query that makes a new table but that results in having all previous made offers into the table confirmed orders which of course is not what I want.
It might be stupid of me, but I've been breaking my head for over a day now on this issue and didn't figure it out yet....so please help.
Tnx!
I need your help. What I have is several tables but the problem I have now is:
I have a table in which I save (via a form) the offers we made to customers. What I want to do now is when a customer approves an offer to select this specific order and then save it into a different table called "confirmed orders". I don't seem to be able to figure out what to do. I tried making a query that makes a new table but that results in having all previous made offers into the table confirmed orders which of course is not what I want.
It might be stupid of me, but I've been breaking my head for over a day now on this issue and didn't figure it out yet....so please help.
Tnx!