lookup filed sort

From: André Dantas Rocha (ad-rocha_at_uol.com.br)
Date: 11/26/04 

Date: Thu, 25 Nov 2004 21:31:33 -0200

Hi,

How can I sort an ADODataSet by a lookup field?

Thanks,

Andre

Relevant Pages

  • Re: Bonkers over a combo box`
    ... which you described in your first post in this thread. ... these newsgroups advise *against* using a Lookup field in any table, ... Row source type: Table/Query ... the list of options doesn't sort alphabetically. ...
    (microsoft.public.access.forms)
  • Re: IndexDefs with ADO and Access
    ... Apparently Access database sort the indexes by name. ... > property of ADODataset not always seems to not reflect this order. ... > fill my list iterating through the array. ... IndexFieldNames property and generate your own code for the user to select ...
    (borland.public.delphi.database.ado)
  • Re: Last question for awhile...
    ... define a "lookup field" in a table. ... On first glance, it might appear to be "more elegant," but you are very ... It just seems like a sort of loophole way of solving the problem rather ... that stores those values and then use a different row source type of ...
    (comp.databases.ms-access)
  • Re: Tasmanian Adventure
    ... Andre loves it... ... Nutella, too (hazelnut chocolate spread) but we can find that here now. ... is an extremely foul concoction allegedly from some sort of berry, ...
    (rec.music.gdead)
  • Re: About lookup fields..
    ... Then I enter statement: ADOQuery1.Sort:= 'Nameoflookupfield'. ... And what I get the error message: ... You can sort by ... >> Does ADOTable component allows to index or sort itself on lookup field? ...
    (borland.public.delphi.database.ado)