question on Access 2007 datasheet filter

[Mark Andrews]

In an Access 2007 datasheet you have those arrows in every column that
display sorting, filtering and unique values.

I'm wondering why on some fields I see unique values and on some I don't.

For example: I have tblDonation which is related to tblContact and
tblCampaign

I have two combo boxes in the datasheet both based on sql and each has the
corresponding id and text value (bound to hidden id).

However the contact shows unique values and the campaign does not???


I haven't changed any option in Access (still set at 1000 values and indexed
and non-indexed fields).

I have about 10 records in the database in each table.

Could someone help me get it so my campaign combo box shows unique values?
Is it indexing, relationships, some trick etc...?

Thanks,
Mark

 

[Mark Andrews]

FYI: I figured it out, I had an alais in my sql behind the combo box for the
campaign
example:
select tblCampaign.campaignid, tblCampaign.CampaignName as XXX from
tblCampaign

I just took out the "as XXX" and it worked fine.

The combo box always worked but to get unique values on filtering a
datasheet, I guess alaises are bad.

Mark