3 Replies Latest reply on Apr 23, 2012 4:54 PM by philmodjunk

    Seeking alternative way for creating a related record through a very large value list portal field.

    EricTsibertzopoulos

      Title

      Seeking alternative way for creating a related record through a very large value list portal field.

      Post

      I have a table named "Hosts" and a related table named "Components".  It is a many-to-many relationship so there is a join table named "HostComponents".  The Components table has a lot of records. I have a value list field on the HostComponents portal for the ComponentID. When I try to create a new HostComponent record through the portal on the Hosts layout, the componentID value list length makes it impractical to find a component record.

      How can I implement, in FileMaker pro 12,  a Bento-Like "related data" lookup layout that allows me to select multiple records (lines) from the related Components table and create the new records in the HostComponent join table?

      Thank you

      Eric T.