Set field?

[jeffmcg]

I am try to write a script that creates a new record in my tasks table.

task table:

taskname

tasktype

contact

I want my contact to be populated with my current record from my contact table current.

contact table:

name

phonenumber

i have tried...

goto layout ["task"(task)]

new record/request

set field [task::contact ;contact::name]

this doesnt work. I am missing something, just not sure what.

[mr_vodka]

Set Variable [ $Name; contact::name ]

go to layout ["task"(task)]

new record/request

set field [task::contact; $Name]

I would recommend using a ContactID number as your key rather than contact name.

[jeffmcg]

Thanks for the help mr V. It works perfect, I am using Contact ID instead of name.