Create a Query that joins the Product with the Sales.
Have a Criteria of the ProductID
Make this a Continuous Form
You could then have a Double Click event on your ProductF which opens this.
Or anywhere you have that a product showing in a Form.

I would check out the Inventory Management video.

Even though you are placing the order for Customer 1 you may also have customer 3, 5, and 12's items in the same order.  Correct?

Even though you have the items from the catalog at a certain price - you pay a lesser price and that is how you make your income correct?  I would want to be tracking my income / profit as well as being able to have the history for the individual customer.

You say that you don't inventory but in actuality you do.  The time of turn over is just very low.
In my mind, you need to separate out the order of the product(s) from your vendor - Avon - from the Sales of those products to your customers.

So you bring in inventory.  Then you sell it, or move it out of inventory, to your customer.  Two different transactions.

Are you able to download a list of products and / or prices from Avon?
That would be very helpful to you as far as maintaining your product list and placing orders with them.
Richard has videos on updating product lists that we can point you to as well.

In addition if you can upload orders vs having to type in things you could consolidate what you need from your individual customers and upload the total order to Avon.

Thank you all for the feedback. I will dig in using the suggested solutions.

"Reminding customers it's time to order again" is actually one of the topics I have on my TechHelp list for an upcoming video. Hang in there. :)