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

Value Lists vs. simple tables for validation


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

Recommended Posts

  • Newbies
Posted

The example, a serialized products table that includes a number of fields describing the product. In other DBs I would create individual tables for the descriptive fields related with an ID, or put them all in one related table linked with an ID and a type.

Filemaker appears to prefer using value lists for many things I might normally use tables. Is this one of them?

The end goal is to populate drop-down lists in a products portal with auto completion and the ability to use the tab key to commit the selection to the field.

The reason I'm having trouble doing things my more traditional way is because of this statement from the help file regarding auto-completion:

"Auto-complete is not supported in drop-down lists when the value list used is configured to use Also display values from second field, Show values only from second field, or Sort by second field."

This topic is 5909 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.