View Full Version : Cannot add records; join key of Table Products not in recordset


Aaron
09-05-2000, 07:21 PM
This is the error message I get when I try to create a form, like the Products form in the NorthWind Database, and enter a new ProductName without inputing a CategoryName or SupplierName. How is it that you can enter new products into the NorthWind's Products form without error and without selecting a SupplierName or CategoryName? The Products to Supplier and Products to Category relationship is many to one in both cases; this should dictate that you can't add new values on the many side without something on the one side - but in their form you can. In my form you can't. Please help!