Search for members of value list

[liltbrockie]

What is the easiest way to perform a search for all members of a value list?

[comment]

it depends on the circumstances. In general, you can either enter Find mode, then loop over the list to create a find request for each item, or define a relationship based on a global/calculation field containing the value list items, then use Go to Related Record to find the records.

[liltbrockie]

it depends on the circumstances. In general, you can either enter Find mode, then loop over the list to create a find request for each item, or define a relationship based on a global/calculation field containing the value list items, then use Go to Related Record to find the records.

Yep... think ill do the loop... just wondered if there was a secret easy way! Thanks Comment!

[Salin]

I have 500 IDs in an Excel spreadsheet and need to find them from FM database. What is the best way to read each ID from the Excel file? Do you have a sample script for a loop and compare values? Thanks.

[comment]

What is the best way to read each ID from the Excel file?

 

I believe importing them is the only way. Once you have them in their own table, you can use a relationship to find the matching records in your data table..