Hi

I have a table named "program" and I have a table named "form"

In "program " I have a field named "Billingname" and I want the contents of that field to be inserted in the table "Form" in the Field

"Name". I did a script calculation where it insert calculated result

in the new text field. It doesn't work. Is the only way to do this in a script by cutting and pasting?

Thanks

Dave

Hi

are those tables related ?

no they are not related.

Is there no way to do this with an unrelated table?

I think Daniele asked that question as a way of eliciting more information about what you're doing and what your problem is.

The short answer is, no, the only way is most definitely not cut/paste. But there are so many things that might be broken about what you're attempting that it's hard to diagnose without more details.

Are you attempting to set a field in a specific record in Form? Or whatever the current record in Form is? Or any record at all?

How are you grabbing the Billingname value from the first table?

How are you navigating from the Program table context to the Form table context? ARE you navigating between the contexts?

How are you setting the Name field to the Billingname value?

What calculated result are you inserting? What's the context of the layout you're on when the insert calculated result script step is executed?

I can think of other questions, but that ought to get you started.

without other specifications, you can try this:

Set Variable [ $name: Value: program::Billingname ]

Go to Layout ["form"(form)]

New Record/Request

Set Field [ form::Name; $name]

Possibly a simple import. I think we now have ALL the bases covered. Give skinny information, get skinny information... :smirk: