Jump to content

Related Value Lists Don't Work (ugh)


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

Recommended Posts

Here's one for everyone to chomp on...

My users are creating new records. On the "New Record" format page, I'm passing simple information to speed the data entry (i.e. the current date, their username, etc.) I am also setting up some of the fields as entries with Value Lists....Now the curious thing is this all works...EXCEPT! When I use a Value List that shows only "related values" it doesn't work...zilch....nothing. But change the exact same value list to show ALL values from a field and it works fine. Go figure! My best guess is that FileMaker doesn't index Value Lists within itself...and as we all know, if a relationship isn't indexed...FileMaker chokes on sending it through Web Companion. Any input on this would be greatly appreciated.

Keep up the great work everyone. This is a wonderful forum.

Cheers. Jeff

Link to comment
Share on other sites

Just to clarify. The related value list mentioned above works from WITHIN FileMaker. It just won't work through the Web Companion. Weird, huh? Anyway, as many of us are forced to do, I found another method for doing what needed to be done.

Thanks,

Jeff

Link to comment
Share on other sites

  • 4 weeks later...

quote:

Originally posted by jwtidwell:

Just to clarify. The related value list mentioned above works from WITHIN FileMaker. It just won't work through the Web Companion. Weird, huh? Anyway, as many of us are forced to do, I found another method for doing what needed to be done.

Thanks,

Jeff

It works through relation as well in HTML. In my scenario, people are entering articles into FileMaker db and one field is filled with keyword from value list.

Keywords are sitting in related database.

Client is presented by ALL values from related database, about 300 list.

Visitor, who searches for article will use not the value list with 300 keywords, but used keywords in db, about 80 of them is in use.

Link to comment
Share on other sites

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