Jump to content

Scripts to translate global fields to another file


This topic is 7676 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 7676 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.