I have two databases.

A Product database: This is very large, housing thousands of manufacturers and hundreds of thousands of products in two related tables: "manufacturers" and "products", linked by the field "company".

An analysis database: This runs analyses on product information that was stored in the "product" database above.

My goal is to make a script that uploads or imports "product" records to the analysis database, and in the process creates new product records that I can analyze independently of the larger database, after the upload or record transfer is complete.

I would like to select a "company" name and upload or transfer all the related "product" records. I also will need to quickly make reports on a few companies at a time, run analyses, and change companies (and repeat comparative analyses), so I would prefer one script that performs rapid uploads. (I want to avoid a multi-step process, like exporting records from the first database and importing in separate steps).

Do you have any suggestions?

I can't figure out how to do this with an import script.

Thank you for considering this.

Fred

PS. I want to keep the two databases separate for a variety of reasons and avoid running analyses in the "Products" database.

"I can't figure out how to do this with an import script."

This seems to be a very straightforward import process. What in particular is the area you're having difficulty with?

I want to import only the records (from a remote database) that match a field in a related table (in my local database).

Hi Fred, and Welcome to the Forum,

Read about the [color:blue] Methods of importing data into an existing file in your user guide, or the Online Help with FileMaker Open, here is a link to what you should find in the help. Link

Note the = used for matching the field.

HTH

Lee