No Luck
Thanks Ray; I have tried and re-tried most of today with no luck! I used diffreent alias but the DA Search dialog always selects BOTH fields and defaults the type to List.
I tried qualifying the field as you suggested and it does not filter the recordset.
I tried using a different alias name - the recordset shows the right alias, but DA Search still brings in the table fields.
It seems to me that DA Search does not consider the alias name and pulls in the unqualified field names instead.
What do you recommend I do in this case?
Thanks