I have two databases. Each record has a number in both databases I want to write a script that will take a number from the fist data base and preform a find in the second data base.

1. Set up a relationship between the 2 databases based on the number field.

2. Create a script:

Go to related record - show only related records.

When you run the script, it will automatically find all of the records in the related file.