Pulling records from a table

[monsnow]

Hi,

I have several layouts based on one table related to about 5 others. The main table contains 150k records, I do a search for what I need and 'move' it to another layout. This layout contains about 200 records, but I only want to work with around 15 or so that are 'active'. What is the best way to approach this?

Thanks, Michael

[Vaughan]

Perform a find?

Layouts do not contain records: layouts display fields from tables. Each layout is associated with one table (or to be completely acurate, one Table Occurance or TO) and it's the associated table that has records in it.

[transpower]

Add an activity field (flag) to the second table. Set the 15 active records to "active." You can perform a find script so that only the active records are displayed.