Hi,

If you are in a layout and you have a field or a number of fields, say a table of Music Groups information and you would like to put this information into another table, say called "Managers", then what is the best way to do this?

I have found 2 ways so far. First way is using global variables. I set the field(s) I want to copy into a global field in the same table. I then switch to another layout, and then do a Set Field on the record in the other layout using the global variable.

Set Field [bands::gBandName; bands::name]

Go to Layout ["manager layout" (managers)]

Set Field [managers::band_I_manage; bands::gBandName]

The second way is to use Copy / Paste and toggle the layouts- although it seems for more than one field you would have to switch back and forth between the 2 layouts. With one field, I see no flicker... yet.

Copy [select; bands::name]

Go to layout ["manager layout" (managers)]

Paste [select; No Style; managers::band_i_manage]

- but for each field you want to copy, you have to switch back to the other layout.

what is the best way ?

thanks for your help in advance,

sincerely,

J__

There is a 3rd option and that is to combine SET FIELD with a relationship so you can avoid using the global fields. What that relationship should look like isn't easily answered without having a look at the structure of your solution.

Generally SET FIELD is preferred over COPY/PASTE for two reasons:

- it does not destroy anything the user has put on the clipboard

- the field does not have to be on the layout that is frontmost when the script runs

Hi,

Thanks for the response.

Could you please elaborate on this approach with the relations, how would you combine set fields with a relationship?

I wasn't thinking about the clipboard - good point. I have been using Set Field, but read something somewhere and wondered (am wondering) if there is a better preferred way to do this.

thanks for the response again,

sincerely,

J__