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

    How to create a combo-box ala Ms Access

    WillieFred

      Title

      How to create a combo-box ala Ms Access

      Post

      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)