The company for which I work has just bought me version 5.2. I have a grid of organisations. The organisations have many users. One of the required search criteria is entering a username and having the grid filter to display organisations which have a user that has that username. This would require taking the entered username from the search dialog, searching a user table, returning the organisation/organisations that have users with that username and then filtering the organisation grid. Please let me know if this possible, and if so, how it is implemented.
Thanks Will. We could use a join and have a huge list of possibilities in a hidden column but have come up with a different solution to this issue where we need to take the result from a search dialog and use it to get a list of IDs from a table not associated with the grid, then use those IDs to filter the grid. We have done this by capturing the $_GET after the search dialog ‘Find’ is clicked. Extracted the relevant data, selected the IDs against this data from the external table and fed it back to the select statement after unsetting the fictitious column from the search filter and feeding the rest back into the $_GET.