[Solved] Filtertable containing concatenated field

[gkick]

Hi there,

Having a bit of a conundrum. I need to construct a filter table which will have two list box inputs one of which is a concatenated field from a query.

The filter table will see an id,Contact (i.e. FirstName||' '||LastName),Category,SubCategory and LastName, all fields with the exception of Contact being sorted ASC.

Feeding listboxes are Contact and SubCategory.

The problem I face is the concatenation as the query for the filter table does not accept the concatenation as a valid criteria. The LastName field only serves the purpose of sorting the concatenated Contacts by the LastName part.
Would be grateful for any known work around.
Thanks

EDIT: Solved by using the filter mechanisms of the navbar instead.