access requires a value in a field but i have required set to no???

[samos1023]

i have a table(tblInventory). It has a field in it called RoomID. This field has a relationship with the ID field of the tblRoom table. In the tblInventory I have set the required setting to no. When I try to enter a new record if i leave the field blank, i get this notice



"You can not add or change a record because a related record is required in the table "tblRoom"

Why am I getting this error if the required setting is set to no?

[pbaldy]

You have specified enforce referential integrity in the relationships window. Since (presumably) there is no record in tblRoom with a Null RoomID, you get the error.