Find a set of 70 records in 1000... how?

[Cabinetman]

Context: 1000+ records, Each record contains a unique # in field1

I have a random 70 +/- records at any given time that I need to quickly pull out and then edit or delete.

How can I find them without going through a list 1 at a time??

[Vaughan]

To save a found set, copy the recordID and paste them into a global field or a normal field in a prefs table. Then use the GTRR to "find" the found set again based.

[Cabinetman]

I'm not saving a found set. These change daily

Maybe a better explanation.....

Basically I have 1000+ items listed for sale online.

Lets say tomorrow I can no longer get 70 of them so I go to my database with this comma separated list and want to find all 70 without - as I ended up doing - creating 3 fields to:

field 1 = Take the list of items I wanted to delete

field 2 = calc to single out the first item

field 3 = calc to get field 1 less the first item

and search 1 at a time. resetting the fields after each find..

It seems like I should be able to create a list and find all records matching each separated value.

[mr_vodka]

Same concept slightly modified. As Vaughn said, you could set a global field with a list of the items that you want to find and then use a GTRR. As for your field 2 and 3 I dont follow.

BTW I dont see why you would delete an item that you no longer have. Instead you should just have a flag called active that returns a boolean result.

[Cabinetman]

This is an ever changing list of items that are uploaded several times a week to various sites.

I maintain a separate table that keeps all items ever listed so if it comes back in stock I can enter 1 number (UPC, ISBN, whatever) and set the new quantities to relist.

I don't need to keep anything not listed... So I do a quick find in the main database to check available quantities.. if to low or if I sold out through another site I need a quick find of the list .. and so on.

ANYWAY... I was just looking to see if there was a find request option where you can enter all the records you want to find as a list and pull them out as a found set for editing...

[Ocean West]

Use relationships is much faster than finding...

create a global field where you put in a returns separated list of the items you wish to exclude. Type it in or paste it in from your other sources.

create a field that gets the list of all items in your found set..

http://www.briandunning.com/cf/439

Create a field that "Zaps" the ones you don't want from your first field.

http://www.briandunning.com/cf/193

Use this field as basis for a relationship and do GoTo relationship.