Compare 2 fields from different databases

[chuckcou]

2 files-- Both File Maker

Database: Main, Table: Main

Database: Export, Table: Export

If Database: Export

Table: Export

Field Name: DESCRIPTION

=

Database: Main

Table: Main

Field Name: DESC

Set Field

Database: Main

Table: Main

Field: Confirm = YES

I would think I would need to do a loop to loop thru table to look for the match.

I believe I understand the logic. I am not sure how to call the other database from within the script.

Thanks for you help

[comment]

That's what relationships are for. Relate the two tables, matching on the description fields.

[chuckcou]

hmm checking it out now. I have related many tables within a single database, but never two different databases. This should be interestiong. Ya, if what you are saying works, then this would be quite easy. :(

[comment]

See section 5 here:

http://www.filemaker.com/help/07-Related%20files14.html

[chuckcou]

Wow, now that is cool. Talking about opening up possiblities. Thanks for that tip. Never really had to work with two separte database before(well maybe in dbaseIII), but back then a database tables where files

[color:red]One more question--When would you use the import command within a script?

If you can relate two table then you can use set field to import.

[comment]

I don't think I can answer that (other than "when I need to import records" ). I am not sure what you're doing, but it seems to me that once you have the relationship, you should be done. The related data is available - why duplicate it?

[chuckcou]

Sorry about the confusion. The solution you gave worked like a charm.

I was just thinking of a different situation not related to this subject. If you can setup a relationship you can do the same thing as import. Thus, why have an import? I guess easy of use would be top on the list.

Can you specify during an import some records to be imported and some not to be? Or does import have to bring all records into the table?

Just trying to learn. Thank for you time and knowledge.

chuck

[comment]

I'm afraid those are very broad questions, not easily answered without going into a lot of if's and when's. In general, I try not to import data that already exists in the system.