Interesting Value List Quirk 
Author Message
 Interesting Value List Quirk

I have a field in one database (Alpha) that takes it's valid entries from a
pop-up menu value list created from the contents of a date field plus the
contents of text field in a different database (Beta). Interestingly, even
though I've sorted the records in "Beta" so that they are in chron order
based on the date field, the value list always displays as alphabetical
order, based on the values in the text field. Also, I note that some values
available in "Beta" are missing in "Alpha."

I can find nowhere to set the sort order for a dynamic value list. Any
Clues? How about missing entries in the value list?

Mark Hurty



Thu, 31 Jul 2003 01:25:36 GMT
 Interesting Value List Quirk

The sort order in a value list is always alphabetical, independently of the
sort order of the found set or, in a related field, the sort order of the
relationship.

Don't know why values from Beta are missing. Not clear excactly what you
mean by "plus the contents of a text fields...". Value lists display only
values from the same database, unless you mean you are using a concatenated
calculation field. We might be able to help more if you tell us more about
how that second field from Beta is connected to the value list.
--
John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> I have a field in one database (Alpha) that takes it's valid entries from
a
> pop-up menu value list created from the contents of a date field plus the
> contents of text field in a different database (Beta). Interestingly, even
> though I've sorted the records in "Beta" so that they are in chron order
> based on the date field, the value list always displays as alphabetical
> order, based on the values in the text field. Also, I note that some
values
> available in "Beta" are missing in "Alpha."

> I can find nowhere to set the sort order for a dynamic value list. Any
> Clues? How about missing entries in the value list?

> Mark Hurty



Thu, 31 Jul 2003 02:35:44 GMT
 Interesting Value List Quirk
Sounds like Mark has referenced two fields (date and text) as the values
for a pop-up list which might explain why some of the values are missing.
The values in the second field that is referenced must be unique.  If
there any duplications (even if the values in the first field are unique)
only one (the first) will show in the value list.

You could try redefining the second (text) field so that it is not indexed
which will force FileMaker to sort by the first (date) field - however,
then the problem of unique values will shift to the date field.

--
Bridget Eley


Quote:

> The sort order in a value list is always alphabetical, independently of the
> sort order of the found set or, in a related field, the sort order of the
> relationship.

> Don't know why values from Beta are missing. Not clear excactly what you
> mean by "plus the contents of a text fields...". Value lists display only
> values from the same database, unless you mean you are using a concatenated
> calculation field. We might be able to help more if you tell us more about
> how that second field from Beta is connected to the value list.
> --
> John Weinshel
> Datagrace
> Associate Member, Filemaker Solutions Alliance
> Vashon Island, WA
> (206) 463-1634



> > I have a field in one database (Alpha) that takes it's valid entries from
> a
> > pop-up menu value list created from the contents of a date field plus the
> > contents of text field in a different database (Beta). Interestingly, even
> > though I've sorted the records in "Beta" so that they are in chron order
> > based on the date field, the value list always displays as alphabetical
> > order, based on the values in the text field. Also, I note that some
> values
> > available in "Beta" are missing in "Alpha."

> > I can find nowhere to set the sort order for a dynamic value list. Any
> > Clues? How about missing entries in the value list?

> > Mark Hurty



Thu, 31 Jul 2003 05:12:13 GMT
 Interesting Value List Quirk

Quote:
> The sort order in a value list is always alphabetical, independently of the
> sort order of the found set or, in a related field, the sort order of the
> relationship.

Your comment below got me thinking about using a concatenation to solve the
problem. I was blinded by my frustration at Filemaker's seeming limitation,
and missed an obvious way to solve my relatively simple problem.  FYI I've
noted below what I was trying to solve last night...It's still intriguing,
if now merely academic.

Quote:
> Don't know why values from Beta are missing. Not clear excactly what you
> mean by "plus the contents of a text fields...". Value lists display only
> values from the same database, unless you mean you are using a concatenated
> calculation field. We might be able to help more if you tell us more about
> how that second field from Beta is connected to the value list.

In the dialog to set up a value list from a field in a database, I can
interact with three things: 1) a button to specify which file to use (the
file need not have a relationship with the database you are calling the
values from -- you select it via a standard OS file dialog), 2) A scrolling
list box with the names of the fields in the file specified in step 1 and,
3) a checkbox with the label "Also display Values from:" and then a second
scrolling list box with a duplicate set of the names of the fields in the
selected file. I specified a file, and chose one field from each scrolling
box (You cannot multi-select from these list boxes.)

The odd thing is that Filemaker sorts based on the values from the second
box, not the first box. If I switch, and choose the items from the opposite
boxes, It does indeed sort in the values order I desire, but now the line
for each item is listed backwards in my pop-up menu.

So, for example what I want the list to look like is
A - (Sorted by Date, with Date listed first):

   02/28/2001  A Class Name
   03/13/2001  C Class Name
   04/15/2001  B Class Name
   05/12/2001  Z Class Name
   06/18/2001  D Class Name

But I can only get either
B - (Sorted by Class Title, with date listed first):

   02/28/2001  A Class Name
   04/15/2001  B Class Name
   03/13/2001  C Class Name
   06/18/2001  D Class Name
   05/12/2001  Z Class Name

OR:
C - (Sorted by Date, with class title listed first):

   A Class Name  02/28/2001
   C Class Name  03/13/2001
   B Class Name  04/15/2001
   Z Class Name  05/12/2001
   D Class Name  06/18/2001

Options B and C are bad human interaction design -- the apparent randomness
of the first character you see in the list masks the fact that the list is
actually sorted in a useful order.

Mark

Quote:

>> I have a field in one database (Alpha) that takes it's valid entries from a
>> pop-up menu value list created from the contents of a date field plus the
>> contents of text field in a different database (Beta). Interestingly, even
>> though I've sorted the records in "Beta" so that they are in chron order
>> based on the date field, the value list always displays as alphabetical
>> order, based on the values in the text field. Also, I note that some values
>> available in "Beta" are missing in "Alpha."

>> I can find nowhere to set the sort order for a dynamic value list. Any Clues?
>> How about missing entries in the value list?

>> Mark Hurty



Thu, 31 Jul 2003 05:43:24 GMT
 Interesting Value List Quirk
You've hit it exactly. I did not understand the limitation on the uniqueness
of the values in the second field, nor the odd sort order imposed by
Filemaker. The solution, however was quite simple. Build a calculation field
and concatenate the date, the class name, and in my case include the name of
the teacher. This creates a fairly unique set of data -- until any of the
teachers in this small organization start teaching the same class twice on
the same day. This allowed me, subsequently to build a relationship between
the database of students and database of classes using the concatenated
field as the key. In the end I am able to accomplish all that I had hoped...

Thanks for your comments and to John Weinshel for his suggestion that made
it all come together.

Mark


Quote:
> Sounds like Mark has referenced two fields (date and text) as the values
> for a pop-up list which might explain why some of the values are missing.
> The values in the second field that is referenced must be unique.  If
> there any duplications (even if the values in the first field are unique)
> only one (the first) will show in the value list.

> You could try redefining the second (text) field so that it is not indexed
> which will force FileMaker to sort by the first (date) field - however,
> then the problem of unique values will shift to the date field.

> --
> Bridget Eley



>> The sort order in a value list is always alphabetical, independently of the
>> sort order of the found set or, in a related field, the sort order of the
>> relationship.

>> Don't know why values from Beta are missing. Not clear excactly what you
>> mean by "plus the contents of a text fields...". Value lists display only
>> values from the same database, unless you mean you are using a concatenated
>> calculation field. We might be able to help more if you tell us more about
>> how that second field from Beta is connected to the value list.
>> --
>> John Weinshel
>> Datagrace
>> Associate Member, Filemaker Solutions Alliance
>> Vashon Island, WA
>> (206) 463-1634



>>> I have a field in one database (Alpha) that takes it's valid entries from
>> a
>>> pop-up menu value list created from the contents of a date field plus the
>>> contents of text field in a different database (Beta). Interestingly, even
>>> though I've sorted the records in "Beta" so that they are in chron order
>>> based on the date field, the value list always displays as alphabetical
>>> order, based on the values in the text field. Also, I note that some
>> values
>>> available in "Beta" are missing in "Alpha."

>>> I can find nowhere to set the sort order for a dynamic value list. Any
>>> Clues? How about missing entries in the value list?

>>> Mark Hurty



Thu, 31 Jul 2003 06:21:38 GMT
 Interesting Value List Quirk

Quote:

> I have a field in one database (Alpha) that takes it's valid entries from a
> pop-up menu value list created from the contents of a date field plus the
> contents of text field in a different database (Beta). Interestingly, even
> though I've sorted the records in "Beta" so that they are in chron order
> based on the date field, the value list always displays as alphabetical
> order, based on the values in the text field. Also, I note that some values
> available in "Beta" are missing in "Alpha."

> I can find nowhere to set the sort order for a dynamic value list. Any
> Clues? How about missing entries in the value list?

You may care to check out the article called "Incomplete Value Lists" on
my Web site.

--

http://www.arch.apana.org.au/hiltonb/home.htm
(for all my published FileMaker Pro articles)



Fri, 01 Aug 2003 09:32:40 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. parsing a comma delimited list to use as a value list in an insert

2. Value list and field list

3. How to display value list like HTML list?

4. Insert value list does not match column list.

5. Related values lists with two values does not work with keyboard

6. Distinct display & value in value lists

7. preset values in a value list?

8. Field value base on a radio button value list

9. One value in a check box value list

10. Not a member value of a specified value list on field

11. Add more than one value in a value list [checkbox]

12. making a value selected in a select value list


 
Powered by phpBB® Forum Software