subform won't add new records

[vickiwells]

I'm trying to use a subform to enter records,and I have my relationships or something messed up. I have 3 tables: Orders with fields Order # and other details, Products,with item # and description, and sales, with order#, Item# and description. The subform works fine as long as the item number is already in the Products table, but I need to be able to add a new product right in the subform,if it's not already in the Product table. The products are from a catalog, and I only want the items I actually sell put into the table. What should my relationships be to allow this?

 

[Travis]

If you use a combo box you can use the "NotInList" Event to help you add Items to your Products table.

Otherwise you will need to look at validation code to make sure the product exists prior to trying to save the record. This will require opening the Products input form and saving the new product first.

 

[David R]

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q197526