Data from Parent Record into Address Book

[Daniel Shanahan]

I am able to push data from FMP to Address Book via AppleScript:

tell application "FMPA 11"

	tell current record

		set theFirstName to cellValue of cell "name_first"

		set theLastName to cellValue of cell "name_last"

		set theOrg to cellValue of cell "company"

	end tell

end tell



tell application "Address Book" etc.

But what happens if the Company is not in the current record, but is a Parent Record (e.g. one company has many people).  Is it possible to set a variable to a Parent Record?

tell application "FMPA 11"

	tell current record

		set theFirstName to cellValue of cell "name_first"

		set theLastName to cellValue of cell "name_last"

		set theOrg to cellValue of cell "Company::company"

	end tell

end tell



tell application "Address Book" etc.

Note: 

set theOrg to cellValue of cell "Company::company"

does not work; I'm using it for illustration purposes. Does anyone know what will work, that is, how I can grab the Parent record?

Thanks.

[bruceR]

The expression is valid and should work fine as is; there is some other problem.

[Daniel Shanahan]

Thanks, Bruce. There was another problem. It is working fine now. Thanks for your reply.