AnsweredAssumed Answered

How to create a combo-box ala Ms Access

Question asked by WillieFred on May 22, 2012
Latest reply on May 23, 2012 by 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)

Outcomes