The subject says it all really :)
I have a main data table, joined to a titles table via a lookup, which means rows in the main data table can have multiple titles assigned.
I want to filter my grid showing rows from the main data table (plus the relevant title from the titles table pulled in via an inner join). But I want to filter my grid by makinging MULTIPLE selections in the title dropdown list.
I've come unstuck in my attempts, so here I am looking for expert help :)
Regards,
Richard
I have a main data table, joined to a titles table via a lookup, which means rows in the main data table can have multiple titles assigned.
I want to filter my grid showing rows from the main data table (plus the relevant title from the titles table pulled in via an inner join). But I want to filter my grid by makinging MULTIPLE selections in the title dropdown list.
I've come unstuck in my attempts, so here I am looking for expert help :)
Regards,
Richard