Re: FileMaker Create Record Target
Re: FileMaker Create Record Target
- Subject: Re: FileMaker Create Record Target
- From: Bruce Robertson <email@hidden>
- Date: Wed, 11 Jun 2008 21:28:12 -0700
> The following script will create a record in the frontmost database.
> How can I target the correct database?
>
> I am using FileMaker Pro Advanced 9v3
>
>
> tell application "FileMaker Pro Advanced"
> tell database "Marketing Landscape.fp7"
> tell table "Calendar"
> tell layout "Calendar List"
> -- show
> set vNewRecord to create new record with data
> {vEventName, vDaysLateMax, vEventLocation, vProjectStartDate, vStartDate,
> vEndDate}
>
> end tell
> end tell
> end tell
> end tell
>
>
>
> Thanks,
>
> Jason Bourque
Your script is a little schizoid because of the difference between table and
layout.
A table is the underlying data source.
A layout is based on a table. If you target a layout then data will be
created in the table the layout is based on, in the field order of the
layout.
If you target a table data will be created in creation order of the fields.
I'd skip the table in your case.
tell application "FileMaker Pro Advanced"
tell database "Marketing Landscape.fp7"
tell layout "Calendar List"
-- show
set vNewRecord to create new record with data {vEventName,
vDaysLateMax, vEventLocation, vProjectStartDate, vStartDate, vEndDate}
end tell
end tell
end tell
_______________________________________________
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