Re: Filemaker - since we're at it...
Re: Filemaker - since we're at it...
- Subject: Re: Filemaker - since we're at it...
- From: Malcolm Fitzgerald <email@hidden>
- Date: Sat, 7 Oct 2006 10:15:03 +1000
What I have is a field in our quotes (“OFFERTEN.FP5”) called
“photographe”, which is in fact the mirror of a field “Photographe”
in another DB, our contacts (“KNDStamm.FP5”). I need to get the email
adress ( cell “internete@mail”) from a particular contact, defined by
the “photographe” field from the “OFFERTEN.FP5” DB. The
“KNDStamm.FP5” is open, since the “OFFERTEN.FP5” is linked to it in
many ways, but not visible.
You can do this via relationships through another file. That's an
advantage in some situations, though this doesn't seem to be one of
them. It seems simplest to do what you want to do directly via
applescript.
Presuming cell "photographe" is used to create the relationship between
OFFERTEN and KNDStamm. The data in "photographe" must match the data in
a field (we'll call it "rship field") in KNDStamm.
set myContactID to (get data of cell "photographe" of database
"OFFERTEN.FP5")
set myEmailList to ( get cell "email" of (every record of database
"KNDStamm.FP5" whose cell "rship field" is myContactID )) -- could be
many records
myEmailList
malcolm
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden