Simplest might be to import your spreadsheet into a FileMaker file and then use that table of data to set up the criteria for your finds. What kind of find do you need here, a loop that finds recors for each person one at time to pull the address info for all these people up in one found set? Is it just names that are entered into this spread sheet?
Thank you Phil.
Yes, it is just a list of names. Will you post a link to instructions on how to do as you suggest?
Yes, but what kind of find are you trying to set up?
Assuming that this is a case where you want to use this list to look up the mailing addresses for all the people listed in spreadsheet and then print mailing labels...
I'd have this relationship:
Addresses::FullNameField = ImportTable::FullNameField
Then, instead of performing a find, I'd use a script or button with this step:
Go To Related Record [Show only related records; match found set; From table: Addresses; Using layout: "Address Labels" (Addresses)]
You'd click the button for this on the ImportTable layout immediately after importing.
Note: given the possible issues with data entry errors, alternate spellings for names, duplicate names, I'd put some effort into as much checking as I can between the imported data and the address records before printing address labels.