Cannot add record with newly added value in lookup table (1 Viewer)

RESOLVED: Cannot add record with newly added value in lookup table

I have a database that allows me to select a text option through a drop-down list on a form, where my form field is linked to a lookup table, and the value is then saved numerically in my data table.

I just added a new numerical (and related text) value to my lookup table. When I go to my form, the new text appears in my drop-down list. However, when I try to select it, it tells me the record cannot be saved, because a related value is required in my lookup table. If I try to make the data change directly in the underlying data table, I get the same error.

What am I missing here? Thanks in advance.

It seems you may have tables that are related in a 1 to many relationship, and you are trying to add something to the many side without a related record in the 1 side.
Hopefully you are NOT using lookup fields in a table.

Thank you. I just figured it out - it's in a split database - had to change the backend.