Copy to global field

[Robbydobbs]

Can you copy to more than one global field at a time?

ie..

copy field "db1_customer_number"

set field "db1_g_cust_num"

copy field "db1_code"

set field "db1_g_code"

perform script paste db2:

go to field "db2_id_number"

set field "db1:db1_g_cust_num"

paste "db2_id_number"

go to field "db2_code"

set field "db1:db1_g_code"

paste "db2_code"

[LiveOak]

I think you have some misconception of how copy field an set field are used. You don't need both statements to accomplish a copy operation.

Set Field[db1_g_cust_num, db1_customer_number]

Set Field[db1_g_code,db1_code]

Create fields in both files:

Constant (calculation, number, stored, indexed) = 1

Create a relationship in db2 to db1 with Constant <--> Constant

This relationship will allow you to access global fields in file1 from db2. Yours script in db2 becomes:

Set Field[db2_id_number, NewRelationship::db1_g_cust_num]

Set Field[db2_code, NewRelationship::db1_g_code]

With SetField, you don't need "copy" and "paste" steps.

-bd

[Robbydobbs]

thank you that's a great help.