Hi All,
I have an interesting challenge put before me where I have a solution for all but 1 part.
So here it is...
- A table that adds fields based upon the choices on a menu of possible fields.
- I used a selection of User friendly names in a drop down and conditionally show in the chart table (all fine)
- An ability to drop a list of possible values to compare against a field and bring back results based upon that drop in list.
- I used a variable and Substring search /replace and triggered field results (select in field) - All fine
- No we want o have the drop in list from one set of results provide the results as above, but another drop list of possible results to return these values ON TOP of the existing set of data - not either or nor do I need it to cross referrence both results.
So - Lets say I drop in Employee IDs 111,222 1nd 333
Then I want a Manager list of M123,M234 who lets say have 1 employee each 001 and 002.
My result wished for is 001,002,111,222 and 333.
Any thoughts on how to get there anyone - I am getting either or as they are not the same field and limit on one or other
Peter
Message was edited by: Peter Lawlor
Am I alone in such a query results builder?
