> How can I tell IBO that any searches on the ItemID column is
> referring to 'a.id'? I need to use column aliases because the
> queries are dynamic.

Not sure. But since your queries are truly dynamic why are you using
column aliases at all? If you just want user friendly names why not
setup the FieldsDisplayLabel properties when you setup the query?

--
Geoff Worboys
Telesis Computing