Re: Filemaker: referring to a "mirror" cell value
Re: Filemaker: referring to a "mirror" cell value
- Subject: Re: Filemaker: referring to a "mirror" cell value
- From: Malcolm Fitzgerald <email@hidden>
- Date: Thu, 26 Jul 2007 13:47:28 +1000
On 25/07/2007, at 6:43 PM, Jay Louvion wrote:
Hi all, sorry about the quirky title, but I didn’t quite know how
to put it any clearer.
I have a DB of clients (“KNDStamm”) and a DB of Quotes (“Offerten”).
There are a few cells in “Offerten” that “mirror” data of the
corresponding record in “KNDStamm” - when I say corresponding, I
mean there is a cell in Offerten that represents the client’s
number in KNDStamm and the clients names and numbers appear in
“Offerten” (though not in modifiable cells).
How can I refer to this data ? The layer mode gives me “::VName”
for example, but how can I use that ?
This is the faulty excerpt of code I have so far:
[...]
set FirstName to cellValue of cell "VName" of current record of
layout "Eingabe" of document "KndStamm" —DOESN’T WORK – OBJECT NOT
FOUND
set LastName to cellValue of cell "NName" of current record of
layout "Eingabe" of document "KndStamm" —DOESN’T WORK – OBJECT NOT
FOUND
set TelNr to cellValue of cell "T portable" of current record of
layout "Eingabe" of document "KndStamm" —DOESN’T WORK – OBJECT NOT
FOUND
[...]
Any ideas would help me enormously, this is my most crucial problem
right now.
the cell names from different tables are prefixed with the table name
( or the name of the table instance when you have the same table
referenced multiple times in relationships) and two colons.
So a cell in table "KNDStamm" is "VName". When you put that cell onto
a layout that uses table "Offerten" the name of the cell is
"KNDStamm::VName".
I find that it is best to make layouts for Applescripts. Put nothing
on the layout except the fields that you want to use. You can then go
to layout and get record.
Malcolm
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden