Adding line items to an order

[torb123]

I am sure this has been discussed before, but I didn't find anything while searching.

I have an order form set up similar to the order form in the Northwind database. The individual products are related to the order through the subform, using ProductID. The way it is set up, you can not add a line item to an order unless it exists as a product. I have been given the task to see if it is possible to add an item to the order that is not in the products database.
The reason for this is many times we sell things that we will never sell again, or many small items put together as a package, and don’t want to take the time to put it in as a product if we can just quickly write it up on the order (subform) itself.
Is this possible, and if so, how?
If you think it is possible and you need more information or clarification, please let me know.

Thank you,

Eric

 

[randy700]

If you're using a combo box to select the product, consider using the Not In List event.


Randy

 

[payback]

If you want to ensure integrity of the orders and sales, you should look at creating a Miscellaneous product but have the ability to change the description on the order to what you want.

 

[torb123]

Thank you for your responses.
Payback, I currently don't have a product description, and that should work out fine. Hadn't thought of it before, thanks again.