portal - FileMaker Pro pop up values from related table -
i have portal in contacts table layout shows related mention in second "mentions" table. related table has relationship third "sources" table want user select when view data in "mentions" portal of "contacts" layout. works part. problem comes when user changes "source" in portal attempts change "source" in next portal row t change "source" last select source regardless make selection
any ideas ?
here screen shots of how have setup
portal , specified field
and field control setup
and relationship
you modifying value of source field in sources table, not want. want use data populate value list , store serial number of source (or source text) in mentions table.
1) create value list sources using values sources field.
2) create new field in mentions table called 'source.'
3) add field portal , remove current sources field.
4) apply value list new field.
Comments
Post a Comment