Order Entry

[jschneider998]

I have a form that handles the order entry for my database. each order is generated from one company. I have more than one person entering orders on a given day, how can I make the system notify the user that a particular company's order has already been entered for today? Keeping in mind that each company can order the same products on one day, but I don't want to generate more than one order for one company per day...does that make any sense????

 

[llkhoutx]

Create a table which identifies companies having orders for the day. Then before creating a new order, check the first table to see if an order has already been created.

Alternatively have a combobox lookup of companies having current orders for the day. If one exists, add to it; otherwise, create a new order.