Re: Getting a value from one Filemaker DB and see if it exists in another.
Re: Getting a value from one Filemaker DB and see if it exists in another.
- Subject: Re: Getting a value from one Filemaker DB and see if it exists in another.
- From: Malcolm Fitzgerald <email@hidden>
- Date: Thu, 21 Nov 2002 12:06:36 +1100
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
-- document is the current found set
-- database is all records
tell database "Basketball"
show every record whose cell "gameCheck" is myVar
end tell
if (count records of document "Basketball") > 0 then ....
--
Malcolm Fitzgerald
Database Manager
The Australian Society of Authors
_______________________________________________
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.