Need a logical "and" find using 2 fields in portal

[chipper]

I have a main file "Contacts" with a portal showing 2 fields from another file "Donations"(Related by Contact ID). The fields in the portal are "Date" and "Ammount". I want a script that will perform a Find using a logical "and" between "Date" and "Ammount". Currently it performs a logical "or" Find. The only solution I have been able to find, requires concatenation of the 2 fields in the portal. Is there another way to do this?

Thank you,

Chipper

[RalphL]

I recommend that you do the find in the related file. Then you a copy all records to produce a multi-line key. The use GTTR (show) to display the records in other file.

[chipper]

Thanks Ralph for the input.

I moved the Find/Search to the sub file and then triggered it from the main file using an external perform script. I then used a Multi key and GTRR to move the results back to the main file. Works great!

Thanks again!!

[RalphL]

Glad it worked.