simple but needed: limit to list problem

[emzadi]

It's embarrassing to have to ask, but I am trying to enter a code into a field that is related to another table. I have "limit to list" set as "no". The first column is the bound column. Yet, I am getting an error when trying to enter a new code that says "You cannot add or change a record because a related record is required in table "ActionTypes".

Help?
Susan Susan M. Wagner
LAPELS
emzadi1@yahoo.com
susanw@lapels.com

 

[jeevenze]

what kind of relationships do these tables have? Are you entering the "code" using a form?

 

[PhilipSchroevers]

Check the Table definition of the table the field you are trying to enter belongs to. I have a feeling that a Lookup has been defined to the table Action Types.
Another possibility is that a relationship has been defined between the two tables.