use a value list to find records

[tomp]

Can I use a value list to find a set of records?

E.g., finding all records in a table where field x is equal to one of the values in the list?

What would that look like?

TIA

[Raybaudi]

Yes, you can.

If you want only to see those records you need to have:

1) a global text field wich hold the list

2) a portal into your Main Layout that shows record by relationship:

YourTable::gTextField = YourTable2::field x

[tomp]

That's great if I want to 'see'. But I need to 'find' so that I can do a replace. With the 'see' solution I believe I would have to use a 'loop' through the portal entries. OK, but not very elegant!

Is there a way to use the global text = value list in find mode?

Thanks.