[FX.php List] Retrieving values from value list related fields

DC dan.cynosure at dbmscan.com
Wed Nov 8 09:59:16 MST 2006


bob,
if you are pulling the data from a related table to generate the value 
list in the first place, why not just make a separate query to the 
related table (or put the actual fields in the main table's layout) to 
generate your pull down menu instead of trying to figure out the 
intricacies of value lists? using a separate query to the related table 
(or using the actual related fields in your main table and layout) will 
keep the sorts in synch.

my 2,
dan

Bob Patin had written:
> I've got a value list that I'm pulling into my site; the value list  is 
> created from related fields, so each item in the value list has a  
> record from which it's pulled.
> 
> My question: how do I retrieve a 2nd field for each of these value  list 
> items? For example, here is part of a value list:
> 
> Honda Accord
> Honda CR-V
> Honda Oddyssey
> 
> For each of these, there is a corresponding field that contains an  
> image name for each vehicle; I need to give the user the option to  
> display this value list either as a menu (which is how it's working  
> now) or as a page of images.
> 
> I tried creating a 2nd value list containing the images, but they  don't 
> seem to always get sorted the same way.
> 
> When you pull a value list using PHP, does it get sorted, or does it  
> stay in the same order in which it was stored? If the latter is true,  
> then why do my images not always match up? Do they get alphabetized  
> like they would for a pulldown in FileMaker?
> 
> For example, I have cases where there is
> 
> Chrysler PT Cruiser
> Chrysler PT Cruiser Convertible
> 
> For whatever reason, these 2 images get switched, even though the  
> filenames are correct in the database...
> 
> Thanks,
> 
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> http://www.longtermsolutions.com
> 
>   CONTACT US VIA INSTANT MESSAGING:
>      AIM or iChat: longterm1954
>      Yahoo: longterm_solutions
>      MSN: tech at longtermsolutions.com
>      ICQ: 159333060
> 
> 
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
> 


More information about the FX.php_List mailing list