how to fill in a field with a field of another lay

[julietab]

I

[-Queue-]

You need a relationship from table1 to table2 if you want to set a specific record's fields in table1 with data from a specific record in table2. You can use a global to temporarily hold the unique identifer (serial) in table2 and set it to a field in table1 that is defined as the key field in a relationship.

Example:

You have a relationship from table1::table2key to table2::serial. table2::gserial is a global number field.

Go to Layout [table2]

Set Field [table2::gserial; table2::serial]

Go to Layout [table1]

New Record/Request

Set Field [table1::table2key; table2::gserial] <- no relationships are required to access globals across tables

Commit Records/Requests

Set Field [table1::codart; table2::codart] <- a relationship between the two tables' records exists now, so data can be shared.