Is there a way to make opts.PreLoadSearchFilter look at a specific table in an adapter to avoid things like:
Ambiguous column name ‘JobNum’.
Ambiguous column name ‘Company’.
Invalid column name ‘TranID’.
This is what I have for example: opts.PreLoadSearchFilter = “Company = '” + company + "’ ";
I’m trying to get a link to InspNonConf through an InspProcessingAdapter but there are 2 other tables, InspFirstArt, and InspRcpt, that contain the same columns.