[FX.php List] Accessing a dynamic value list?

[Jonathan Schwartz]

I spent a bunch of time trying to get a related 
value lists to work.  The FMPXMLLAYOUT URL 
refuses to recognize related value lists, but 
works fine on the others (Custom Values).

Is this a correct conclusion: You can't uses 
value lists based on related values?

Thanks,

J


At 11:24 PM +0200 8/19/06, Erik Andreas Cayré wrote:
>Content-Type: multipart/signed; micalg=sha1; 
>boundary=Apple-Mail-11--525654047;
>	protocol="application/pkcs7-signature"
>
>
>Den 19/08/2006 kl. 18.11 skrev Bob Patin:
>
>>I have a value list that changes depending on 
>>which record someone views (a dynamic value 
>>list).
>
>So the value list is based on a relation, right?
>Exactly how is the value list defined? (screen dump of dialog?)
>
>>Is there a way to access it in FX and use it on 
>>a PHP page? I've tried everything that I can 
>>think of, but nothing has worked thus far.
>
>As of FX.php 4.2, it seems you can only get at 
>value lists using FMView(), so it's a separate 
>call to FX, just to get the value list.
>I just tested it and noticed FX only return the 
>primary field from the value list, so it can't 
>be used like in FM, where values from a second 
>field can be shown with the primary field data.
>
>>To complicate the question more, how would I 
>>tell FileMaker *which* version of the value 
>>list I would like to see?
>
>You could have a relation starting from a global 
>field, and the value list being based on that 
>relation:
>-Set the global with SetFMGlobal()
>-get the value list with FMView()
>
>>In this app, it works like this:
>>
>>If I pull up "Toyota" in the first pulldown and 
>>click CONTINUE, I go to a 2nd page.
>>On the 2nd page, I want to see a pulldown menu containing all Toyota models.
>>
>>Before you suggest a simple FIND to find all 
>>the records that contain Toyota models, here's 
>>the rub: there are as many as 17 or 18 records 
>>for a single Toyota model, so if I do a FIND 
>>for all records that contain TOYOTA as the 
>>brand, I'll find not a dozen Toyota models, 
>>I'll find over a hundred, and my value list 
>>will have duplicate entries in it.
>>
>>Any ideas? I'm sure this has been faced before, 
>>but couldn't find it in my archives.
>
>If you do the FIND as described, you could use 
>array_unique() to strip the duplicates.
>This may not be feasible, if some finds return 
>too many records leading to mediocre 
>performance...
>
>Let us know how you get on with it...
>
>---
>Erik Andreas Cayré
>Spangsbjerg Møllevej 169
>DK-6705 Esbjerg Ø
>
>Home Tel: +45 75150512
>Mobile: +45 40161183
>
>»If you can't explain it simply, you don't understand it well enough.«
>-- Albert Einstein
>
>»If you don't have time to do it right, when 
>will you have time to do it over?«
>-- John Wooden, basketball coach
>
>
>
>Attachment converted: PowerBookG4 HD:smime.p7s (    /    ) (0016B14C)
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 

Jonathan Schwartz
FileMaker 8 Certified  Developer
Associate Member, FileMaker Solutions Alliance
Schwartz & Company
jonathan at eschwartz.com
http://www.eschwartz.com
http://www.exit445.com