> Hi Dave,
>
[quoted text clipped - 6 lines]
> Thanks a ton!
> Deepti
Absolutely. For that you would have to define the valuelist based on a
relationship, which would have its criteria as salaryfield =
criteriafield (for example), and you can set that it be sorted as
well. (either defining the relationship to be sorted, or by defining
the value list to be sorted -- I think either should work, but would
recomend making the value list sorted not the relationship -- that
will ensure the smaller "distinct' set is sorted, rather than the full
set including duplicates.)
Play around with defining value lists, and read up on them in the
help, to give you sense of what you can accomplish. There are quite a
few options available.
cheers,
Dave
Deepti - 31 Jul 2008 20:36 GMT
Hi Dave,
Thank you for your detailed reply. The problem here is that I need to
display this distinct list as a drop down on form using fx php (which
is tool to use filemaker on the web). So, being able to display the
distinct data is becoming a problem.
Thanks!
Deepti
> > Hi Dave,
>
[quoted text clipped - 22 lines]
> cheers,
> Dave
d-42 - 31 Jul 2008 21:31 GMT
> Hi Dave,
>
[quoted text clipped - 5 lines]
> Thanks!
> Deepti
Once you have it displaying in a value list, its a trivial matter to
capture the list items using the valuelistitems() function, and use it
however you want, including fx php.
Cheers,
Dave