I want to use a table for a lookup field on a data entry layout. My problem is that when I select an item from the popup list, a new record is created in the table from which the popup list derives. I want it to enter the original id from the lookup table into the main table.

Example: I have a database with Recipe as the main table and several related one-to-many tables: Source, Course, and Ingredient. E.g.: Source has a unique IdSo_pk serial primary key, related to IdSo_fk in Recipes and so on.

On a data entry layout based on Recipes, I have lookup fields for each of the related tables. For example for the Source field, what I want is to select

In case anyone is interested, I solved one problem but have come up with another one. I found that on the data entry layout I had the lookup field the Source IdSo_pk instead of the Recipe IdSo_fk. Now the Id is entered correctly in the Recipe table and the Source table remains unchanged.

However, because the Source IdSo_pk is the first field in the Value List, and Source the second, the popup shows: