Check for duplicate data on import

[Stu412]

Hi there

I need to perform a find on Table B while working on Table A from within a running script.  The find is looking for the presence of a specific and constrained piece of data on Table B which, if it's found, should interrupt or halt the script.

So it's effectively If variable1+variable2+variable3 are found together on TableB, abort the script, otherwise continue working on TableA.

The context is that I need to prevent an import of data if it already exists on TableB, using variables 1,2 and 3 as flags.

Hope that makes sense.

Thanks

[comment]

Hope that makes sense.

I'm afraid that's not the case. You can always go to a layout of table B, perform a find, and exist the script of anything is found. You cannot do anything in the middle of an export - if that's what you're asking.

Filemaker does have a mechanism to prevent duplicates being created by import. However, that only works in the same table that you're importing into. Perhaps if you explain in more detail what you need (and why do you need it), another way can be found.