Generate value list from number

[Ron Cates]

Hi All,

I don't know if it is possible but I would like to generate a value list based on a field (Jobs::sets) with a number. If the number is 5 for example, I would like to be able to have a drop down list of numbers 0 - 5 as well as a selection for all. So it might look something like this:

-All-

1

2

3

4

5

Any help is greatly appreciated

[TheTominator]

This can certainly be done with a separate table containing the numeric values you want to display.

Set up a value list to show only values in the related table starting from the current table. The relationship is values less than or equal to the number you have in your field (e.g. 5).

[Ron Cates]

So let me see if I understand correctly. In a new table I would have a field called number, then create a record for each number up to the maximumum that I need. Then I would create a relationship from Jobs::sets to New Table::numbers ( less than or equal to Jobs::sets ). Then set up a value list based on the number field and showing only values in the related table starting from Jobs?

Is that correct?

Edited September 25, 2009 by Guest

[TheTominator]

Yes, that is correct.

Adding in an extra entry "-Any-" to the value list will be trickier but not impossible. One way might be to add a second field (for value list display) to the new table. An extra record with a number '0' could hold this "-Any-" value so that it would appear on all lists.

[Ron Cates]

I do know a technique for adding the -All- with a calculated field.

xset_select= "-All-" & ¶ & ValueListItems ( Get ( FileName ) ; "Sets" )

So I should be ok there.

I got pulled away from the project today but I am sure I understand it so I should be all set when I get back to it.

Thanks so much for the help.

[comment]

See if this helps:

http://www.fmforums.com/forum/showtopic.php?tid/155474/