4 Replies Latest reply on May 23, 2012 12:50 PM by WillieFred

    How to create a combo-box ala Ms Access



      How to create a combo-box ala Ms Access


      I've been doing quite some searches but I dont seem to manage the following.

      I want a combo-box /drop-down / pop-up with the following features:

      1) Look-up and store a foreign key

      2) Show not the key but the text e.g. Name

      3) Type-head

      4) After selection keep showing the name (not the ID)


      As far as I have managed now: 

      Drop-down list: 1 + 2, but type ahead (auto complete)and showing the name instead of ID does not work

      Pop-up menu: 1 + 2 + 4 work. But the very important one: type-ahead is not working)


      (Just changing from Access to Filemaker, so maybe I'm trying to tackle the problem from the wrong end, but this is an essential feature, which that might change me back to Access)