Getting a value from one Filemaker DB and see if it exists in another. A method revealed
Getting a value from one Filemaker DB and see if it exists in another. A method revealed
- Subject: Getting a value from one Filemaker DB and see if it exists in another. A method revealed
- From: Dan Doughtie <email@hidden>
- Date: Tue, 26 Nov 2002 11:12:25 -0500
Okay. I solved my own problem by stumbling on something I haven9t found in
any documentation.
If you set a repeating field9s values against a list the items in the list
will go into the repeating fields in order.
So, I look at a relational DB and see what basketball games are scheduled
and create large variable containing this info. I then look at the list of
opponents in a repeating field with a repeat statement, compare each
repeating field against the game info I collected, if it doesn9t exist I
create a game and then start populating a list that says that 3yes this game
exists2,
set myList to mylist & 3Yes2 which creates {3yes2,2 3yes2}etc. The number of
Yes9s is based on the number of repeats.
When finished I set this list against the repeating field and viola.... What
I9m going to try next is to see if I can create a list of nothing {32,22,22}
then I can throw that against a repeating field to clear it.
Set myCount to lastRepetition(or whatever I can9t remember)
SetMyNewList to 32
Repeat from 1 to myCount
Set myNewList to MyNewList to myNewList & 32
End
Not sure that would work but something to start on.
Also, don9t know if throwing a list longer than the repeating field causes
an error. Throwing a shorter list works.
Happy Turkey Day to one and all
Dan Doughtie
Augusta, GA
_______________________________________________
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.