Simple script

[adyf]

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.

[comment]

You need to start by going to a layout of the (unrelated) table you wish to search.

[Matt Malyschko]

Set a variable to copy the data and then set the field to the variable.

[Rick Whitelaw]

Any reason why the tables are not related?

[adyf]

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.

[adyf]

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?

[Matt Malyschko]

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

[comment]

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)?

[adyf]

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.