Unanswered: Lookup from a table with the ability to add new data
I'm not entirely sure how to word this, I've tried a few google searches to no avail so I guess it can't hurt to ask here.
I'm looking to create a form for inputting an order. I want to select the product that the order is related to from a lookup, but be able to -add- the product if it doesn't already exist in the lookup list.
I have an order, I go to input it. The product it's related to is an iPhone 4S, 16GB. The iPhone 4S isn't in my table already, I know this because I've looked through the lookup list. I want to be able to select the iPhone 4S for future orders (to avoid duplicate data) without having to add it manually in the tables.
Any advice? Sorry if I'm not making what I'm asking clear.