Jump to content
Salesforce and other SMB Solutions are coming soon. ×

only showing first of each type of record relating to value list


Recommended Posts

Don't know if the title explains very well what I'm trying to do...


What I want is to omit all records except the first from each catagory. Catagories is a field and the possible values are a, b and c. These values are defined in a value list. I want to write a script which will only show the first record where 'a' is the catagory, the first where 'b' is the catagory and the first where 'c' is the catagory.


I am trying to replace a function which is slowing down a Flash movie I have connected to this database with a server-side script within Filemaker but cannot work out how to compare two different records. In the flash function I have two loops, one within the other, that compares each record to every other record and discards duplicates. Does anyone know if it is even possible to do something like this with Filemaker 5.5? And if it is, any help would be very much appreciated.


Thanks smile.gif

Link to comment
Share on other sites

Hi there,

here's how you can acheive this:


create two global fields myCategoryList and globalRecID


define relationship "categories" from myCategoryList to category

and firstRecord as look-up from field RecID from relationship Categories.


define relationship "onlyFirstOne" from globalRecID to RecordID

( if you don't have it than create it now)


Create an layout with only one field on it:



Create an script named findFirstOnes


Freeze Window
Set error capture [on]
Set Field [globalRecID,""]
Find All
Go Layout [your one field layout]
Copy All records
Go To Layout [ layout with filed globalRecID on It]
Go to Related record ["onlyFirstOne",show only related records]



Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use