[FX.php List] Finding multiple records from multiple values forsame field

[Bob Patin]

That would work if I wanted to use portals, but I have 37 different  
tables, all related to a single table. Rather than have to use 37  
portals on a layout, I query the table directly, depending on which  
table they were just viewing. Since I'm using the same page for the  
initial search results and the constrained search, knowing the table  
name is easy, and since each of the 37 tables uses a very different  
page for displaying results, I merely had to add this small bit of  
code into my results page.

For any of you who might be interested in musical equipment, here's a  
link to the app that I'm building, where you will be able to compare  
products in 37 different mus. equipment categories (digital recording  
consoles, reference monitors, digital workstations, microphones,  
synths, etc.); this is going to be a pretty slick site when it's  
finished:

http://penton.longtermsolutions.com

Only the first 3rd of the 37 tables are done so far; click the COMPARE  
checkboxes to see how my constrain query works...

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: tech at longtermsolutions.com
      ICQ: 159333060

--------------------------
Contact us for FileMaker hosting and programming for all versions of  
FileMaker
PHP • CDML • Full email services • Free DNS hosting • Colocation •  
Consulting


On May 12, 2008, at 9:13 AM, Gjermund Gusland Thorsen wrote:

> Well, the simplest way is to make a new table,
> with a related field, f ex named query of type text in whixh is
> related to Seedling Source TN
> with a portal with the data you need to know.
>
> Then perform an fmnew() to this temporary query table using the  
> following data
>
> $q->AddDBParam('query', 'TN2891' . "\n" . 'TN3531' . "\n" .  
> 'TN3827' );
>
> ggt