October 5, 201213 yr All I'm trying to do is go from one layout to another of an unrelated table and then perform a find as follows: Go to layout Enter find mode Set Field (moved to table; moved from table) Perform Find Set Field won't enter a value and neither will Insert calculated Result. Copy/paste will work and so will Insert Text. I thought Set Field should work with unrelated tables.
October 5, 201213 yr You need to start by going to a layout of the (unrelated) table you wish to search.
October 6, 201213 yr Author You need to start by going to a layout of the (unrelated) table you wish to search. Sorry, I wasn't clear enough on the first script step: Go to layout (unrelated table) I was already doing this. Set a variable to copy the data and then set the field to the variable. I'll try this, thank you.
October 6, 201213 yr Author Set a variable to copy the data and then set the field to the variable. Could I have a bit more info on how to do this please? I can set a variable as part of the script but then what, how do I insert it into the field in find mode?
October 7, 201213 yr Could I have a bit more info on how to do this please? I can set a variable as part of the script but then what, how do I insert it into the field in find mode? For example: Set variable: $ItemID Perform Find - specify find requests - in criteria, match ItemID = $ItemID
October 7, 201213 yr Could I have a bit more info on how to do this please? Why don't you provide more info on what you're trying to accomplish (and why)?
October 8, 201213 yr Author For example: Set variable: $ItemID Perform Find - specify find requests - in criteria, match ItemID = $ItemID This worked, thank you very much. Why don't you provide more info on what you're trying to accomplish (and why)? Comment, not sure what more I could say, I just wanted to go from one layout to another and perform a find all in one script.
Create an account or sign in to comment