Getting a value from one Filemaker DB and see if it exists in another.
Getting a value from one Filemaker DB and see if it exists in another.
- Subject: Getting a value from one Filemaker DB and see if it exists in another.
- From: Dan Doughtie <email@hidden>
- Date: Wed, 20 Nov 2002 10:51:44 -0500
In a nutshell. I can grab a value from a repeating field in one FMP database
by converting the field into a list. I grab one of the items and set it to a
variable. I want to then go and see if a record with that variable9s value
exists in a specific field in another database.
I tried using: (all nested in FMP Tell Statement)
Set myVar to item 1 of opponentsList created from document 3schools2
If exists myVar of cell 3gameCheck2 of document 3Basketball2 then
Set myNewVar to true
Else
Set myNewVar to false.
End
Also tried
If myVar of cell 3gameCheck2 of document 3Basketball2 exists then
Both fail saying it can9t coerce the data.
So my question is.... How do I set a variable then use that variable to see
if that value (in a unique record) exists in another database?
Up till now I have been forced to create a relationship for each repeating
field and if they match then I get a 32 and it verifies that it exists. But
if I keep using that method I will have to create 80 relationships just for
one sport or 160 total. Way too many relationships.
My ultimate goal is to
1 check a repeating field, one repetition at a time. See if that value
exists in the other database, if it does then it does nothing, if it doesn9t
exist then a new record is created in the other DB using data from other
fields in the original db.
The reason. I am scheduling basketball games based on a team9s schedule. The
opponents on that team9s schedule are also in the database so when their
schedules are run you would double enter the games. But if I can check to
see if the game already exists then I won9t recreate it.
Suggestions?
Dan Doughtie
Augusta GA, USA
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.