I have a main table and one of the fields is called "Procedure". This is a lookup field that looks up the data from another table called "Procedure". In the "Procedure" table my users can enter a name and details for different procedures. I created a form where the users can enter main information but when they go to the next entry, I get a error message that says "The Microsoft Office Access database engine cannot find a record in the table 'Procedure' with key matching field(s) 'Procedure'". How can I make this work so that an empty procedure is ok? Is it possible?