There are a few things that I am trying to accomplish here:
1) Use terminal to create a new record in my database.
2) Have that record draw upon a relationship between two tables.
Lets say I have two tables: Shots and Notes. "Shot" is the related
field between the two tables
Here is what I would like to enter in a command line in terminal:
"note VFX001 Lighting Try and get more wrap around the frame left
side"
which would be triggering information to be entered into the following
fields in Filemaker:
"<alias for applescript> <Shots::Shot> <Note:

ept> <Note::Note>"
I need the first three spaces above to tell Filemaker to move to the
next field, but then after that I need all the sentences/spaces to be
added to the final "Note::note" field.
Some info about the set-up:
1) FMP 11
2) OSX 10.6.4
3) Database is remotely hosted
This seems like a tall task, but someone must have wanted to enter
records via terminal before? Any information I have left out?