How do i perform a script to check if a record in table A already exists in table B?
table A contains a list of serial numbers.
table B also contains a list of serial numbers.
i need to run a search on each record in table A to see if it already exists in B.
i would like to do this through a script and a loop - checking each record in A and if it matches anything in B then flag it and go to the next record.
can anyone give me the correct language to use in a FMP script?
both tables are in the same database.