Any Help would be highly appreciated

Here is my question!

I have 2 databases , which have fields called

1) Part#

2) Tracking#

3) Date

4) serial#

I like to import Date and serial# to database1 on

existing records from Database 2 only if part# and

tracking# matches Database1

What should I write in script?

Yes, Kenneth, you are on the right way.

The key is to create, in both the files, a composite key:

KeyMatch=part# & tracking# (assuming that both are strings)

then issuing a relation (MyRelation) based on this key and being sure that duplicates do not exist.

The last step is the serial field (calculated field) definition in the db1:

Set Field (serial,MyRelation::KeyMatch)

And that's all.

Regards & good job.

Arif:

I'm pretty new to filemaker, but I believe that you have to set up a relationship. Go to the 2nd file and click file/define relationships. From there you can define the relationship. You can identify the field that you would like to relate, so the other info shows up. I believe that you must have both files open in order to have the relationship work. Perhaps someone with more experience can elaborate or correct this reply.

Good Luck!