FileMaker Pro pop up values from related table

Question

I have a portal in my contacts table layout that shows related mention in a second "mentions" table. This related table has a relationship to a third "sources" table that I want the user to select from when they view the data in the "mentions" portal of my "contacts" layout. This works for the most part. The problem comes when the user changes the "source" in the portal then attempts to change the "source" in the next portal row t will change the "source" to the last select source regardless to make a selection

any ideas ?

here are some screen shots of how I have it setup

portal and specified field

and field control setup

and the relationship

Answer 1

You are modifying the value of the source field in the sources table, which is not what you want. You only want to use that data to populate your value list and store the serial number of that source (or the source text) in your mentions table.

1) Create a value list from sources using all values from the sources field.

2) Create a new field in the Mentions table called 'source.'

3) Add that field to the portal and remove the current sources field.

4) Apply the value list to your new field.