Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

Typeahead on make/model cond'l value list NAME


This topic is 7123 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

I would like for telephone service representatives to be easily able to enter the make and model of certain equipment a customer has when on a call (to check for compatibility). I am working with an existing database where make and model tables have a numerical filemaker-created unique serial number index and ALSO a common alphanumeric name for the product make and model (I am talking about telephones here, so there are many makes and many models).

How can I set up a value list field popup for make, and then a conditional value list popup for model, where 1) the filemaker-created unique serial number field remains key as the entered value in a record showing a particular customer and their telephone make/model, but 2) where the telephone representative can use "type-ahead" on the associated "Name" (for make and model) rather than on the filemaker-created unique serial number ... in order to speed information entry into the database (since the telephone service representatives have no knowledge of the filemaker-created serial numbers)?

Posted

This used to be available on FM5 and FM6 but seems to been lost in FM7. It doesnt make any sense to allow value lists to include a second field and allow the value list to be sorted by the second field, but then have the type ahead operate on the first field !

I am stuck on this too ! Help !

This topic is 7123 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.