Can anyone point me to a tips and tricks section for formatted searches? I'm not talking about the basics with sql and stuff. I'm talking about something that will explain how to use the advanced features like
Things like that. I've been searching for documentation on any of this stuff, and I can't find it.
In the meantime I'm really trying to figure out how to choose the value in a column in a matrix based on which row is selected.
Suda Sampath replied
The data in the grid is stored in a temp location and is not accessible from the forms through Formatted Search. Generally if you have a formatted search on the header and if you seek the row level value the resulting data would be from the first row.
But in reality it is the context row whose value is picked. If you want to place you cursor on the 2nd or 3rd row and then fire the formatted search then the value from that row would be picked.
FMS are very powerful but if you could give a complete picture of your requirement it will be easier to explain.