Help

[waldon]

I am a novice so I thought I might get some help from the "experts". I have created a order entry database using
Access. It consists of about 5 tables. What I need help with is how to create a table that will update the order when a customer returns the merchandise. Should this included in an existing table or use one of my tables I already have. Thanks

 

[mark curtis]

You can do a couple of things:

Create a yes/no field in your orders table called returned and if something is returned then just go to that record/order and enter a yes in the returned field. That is fine for returns if they are only every so often.

If you are likely to have many daily returns then create the above field and then create an update query and update the returned field where the order no = the returned order or if u have many orderlines to an order then the orderlineno.

Attach the db if u still need help.

 

[waldon]

Thanks for the response!

OK -- I think I will try the second option since returns may happen on a more frequent basis.