[Webinar] Streamline your web hosting managementRegister Today


how do i search against another table's data?

Posted on 2008-01-24
Medium Priority
Last Modified: 2010-04-27
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.
Question by:tabush
  • 2
LVL 28

Accepted Solution

lesouef earned 500 total points
ID: 20739040
you don't need a loop to do that, waste of time.
link both tables using the serial number then check if the linked table::ID is true fro each record.
you can even have a calculated field, say has_B
has_B = if (tableB::serialnb= tableA:serialnb ; "yes" ; "no" )
example upon request...
LVL 28

Expert Comment

ID: 20749202

Author Closing Comment

ID: 31424824

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Suggested Courses

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question