On 04/10/2006, at 6:48 pm, Jay Louvion wrote:
Filemaker returns the following error: “FileMaker Pro got an error: The objet is not an element or a property of this class.” (hopefully not a too hazardous translation from french) on "KNDstamm::EmailAddress".
Yes that was intended as an example only: it assumes you have a relationship defined in the database called "KNDstamm".
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.
It's still a bit difficult suggesting an exact way to do what you're after without knowing the exact structure of your database. But the idea is:
1. Define a relationship (if you haven't already) that links the two photographe fields together, and note the name of the relationship (eg, you might call it "contacts". This name is used in step 3).
2. Isolate the record you want in OFFERTEN.FP5. You might do this via a FileMaker script or via AppleScript. For instance:
show every record of database "offerten.fp5" whose cell "quotenumber" is "1000" -- or whatever your criteria are
3. Use AppleScript to retrieve the email value via the relationship. For instance:
tell database "offerten.fp5"
get cell "contacts::internete@mail" of current record
end tell
I hope that makes more sense?
Thanks many times for your time and patience on this issue. Also, I’m working on FMP 5.5, so some features of AS might not be up to date.
Basic AS support has changed little in FileMaker for some time, so 5.5 isn't a problem in itself for what we're talking about here.