When a field has a relation, a dropdown is presented when inserting values. This might be handy, but sometimes you want to be able to insert an arbitary values.
This behavior has been like this for years. There might be a valid reason to insert an arbitrary value (for example, you plan to insert the corresponding value in the related table later) but I'm afraid that permitting to insert an arbitrary value would defeat the idea of having created a relation in the first place.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Are you talking about an internal relation, or a foreign key?
A relation defined in pMA. Is that called an internal relation?
Did you define it via table Structure > Relation view? If so, this panel is divided in two parts - Internal relations and Foreign key constraints.
I think I used the Internal relations part.
This behavior has been like this for years. There might be a valid reason to insert an arbitrary value (for example, you plan to insert the corresponding value in the related table later) but I'm afraid that permitting to insert an arbitrary value would defeat the idea of having created a relation in the first place.
Defining a relation provides a lot more than just a constraint.
Yes, but the first idea of a relation is consistency between tables.