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

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.

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

It doesn't make any sense to do bulk updates. An order is entered an item at a time and returns should be processed the same way. I would add a return date and a return reason field to the OrderDetails table rather than a flag. That way when something is returned, I could collect potentially valuable information.