Searching multiple conditional vaule lists in IWP

[Linda01]

I have three conditional value lists, each of which is dependant upon the value selected in the previous one.

 

They work perfectly and I have even figured out how to use them when creating a new record in IWP by submitting the record between selections in each drop down.

 

Only one thing left to solve - when I try to do a find in IWP only the values in the first value list show up and now matter what I try I can't get the other lists to work

 

There must be a work around for this

 

All suggestions gratefully received

 

Linda

[AHunter3]

Find Mode in IWP isn't going to work the same way. Unlike native FileMaker Pro, your web browser isn't sitting there "knowing" what related values are out there in other tables, available to generate a value list's contents on-the-fly, as it were.

 

Web browsers aren't database aps; and FileMaker Server can't spew out to them the entirety of the FmPro solution environment.

 

For that matter, even in browse mode you can't pick a value in one field, then go to the next field that has a conditional value list based on the value in the first field, and expect a useful dropdown value list; you'd have to submit changes (post the data), retrieving it back in browse-but-don't-edit mode, then go back into edit-record mode to pick a value for the next field.

[kloveless]

Hello Linda1 -

 

How did you figure out how to submit each value list 1 record to refresh the second list?

 

What script / commands / method did you use?

 

Without using a button based script, I am trying to seamlessly submit a value from list 1, the perform a script-action to submit the record, before selecting values from value list 2.

 

Thanks!

[Linda01]

Hi Kloveless

Its not terribly neat, however you don't actually have to do anything - when you creat a new record just submit between entries to the linked drop downs and they will work. This doesn't apply to find though. If you ever solve that one let me know!

 

Linda