Any Help will be appriciated.

I have three global Fields, gOrderNo = 1000, gProductID = Apple, gOrderQty = 73

And another File ProductLocationFile.fp5

ID Location AvialibleQty

Apple T20 0

Apple A1 10

Apple A2 25

Apple A3 25

Apple A4 25

Need scripts to translate global fields to another File, WarehouseTransation_.fp5

to Look Like This

ID Location OrderQty OrderNo

Apple A1 10 1000

Apple A2 25 1000

Apple A3 25 1000

Apple A4 13 1000

Thank You

Steve

I'm a little confused by "translate" global field from one file to another? If you want to have access to global fields in one file from another file, create a field in each file defined as a calculation (Constant = 1), create a relationship from the file without the globals ("Constant" matches "Constant"), and access the global fields using this relationship. -bd

This pass weekend, I have do some home work. I think I know what needed to do. using Setfield to add the value of the globals to record on other files.

Thank You again