Re: LookUp Fields



I'm using D6 with ADOTables using MS Access 2000 database. I have a lookup
field in Table1. Table2 has the lookup values. In lookup field KeyFields has
two values from Table1 separated by a semicolon. LookupKeyFields has
corresponding values separated by semicolon. When I click on the lookup cell
in the grid, I get the error message ...... Field 'field1;field2' not found.

If I use only one field in KeyFields and LookupKeyFields everything works
properly. What am I doing wrong?
Lookups in grids can only handle one key field
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • LookUp Fields
    ... Table2 has the lookup values. ... In lookup field KeyFields has ... two values from Table1 separated by a semicolon. ...
    (borland.public.delphi.database.ado)
  • Re: Lookup data
    ... ....where G1 contains your lookup value. ... > grid) and the data in each of the columns is sorted alpha-numerically (A & B ... > immediately to the right of the cell that matches the data. ... I had thought about using VLOOKUP but that can't be used to refer ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Populating a field based on lookup values
    ... reckoning I should only need to change the value of the field to lookup i.e. ... Not sure I follow your setup but here is a sample file that does what you ... I also have 6 blank columns headed RowA - Row F, ... I have a lookup table (7x7 grid) that maps rows and columns that I wish to ...
    (microsoft.public.excel.worksheet.functions)
  • optimizing a lookup
    ... I have a large vector and I want to make a lookup to ... find a value and to put it into a grid. ... i.e. for each STN and each minute I have a Vehicle. ... It works fine, except that it is extremely slow, because VLOOKUP function is ...
    (microsoft.public.excel.programming)
  • Re: Lookupfields in grid.. Disappear and reappear :S
    ... Borland ADO wrapper have known problem with lookup fields. ... > For lookupfields in a dbgrid I use a query, ... > When opening the grid, I see the following ... > Watch the first column: ...
    (borland.public.delphi.database.ado)