I'm in need of a script to search for records in one database using data from a field in a second database.

First of all, you must setup your outside database to be sharable and make a name for it.

Next, create a table on your main database with the field you desire (Usually just copy the fields from the remote database).

In the "Relationships" tab, you can edit the properties of the table you just created. You want to make sure that the "Data Source" is from the remote database (We just make this database sharable).

Then, select the table that you want to be able to search on and name it.

Once all of that is setup and linked (if you want linkings in your main database), you can search this table in a script just as you were to search a table that is in your main database.

Essentially, we created a table in your main database and just find the records from the remote (shared) database by specifying the Data Source to be somewhere besides this database.

Hope this helps.

- Dan

Database is not a FileMaker term (believe it or not!).

So, I don't understand your question. Do you have multiple FM files (each with one or more tables)?

Also, sounds as if what you want is to relate the two files (tables), therefore "finding" records that match a value.