Board index » delphi » Help me with using LookUpFields in DBGrid

Philip Kirev

Delphi Developer
Tue, 06 Feb 2001 03:00:00 GMT

Help me with using LookUpFields in DBGrid

I have 2 tables TicketClients.db and Clients.db, field NAME is same in
both and in TickeyClients.db is defined as lookup in Clients.db.
In component TField {NAME in TicketClients.db} I defined:
FieldKind:=fkLookUp
KeyFields:=NAME {TicketClients.db}
LookupDataset:=Table2 {Clients.db}
LookUPCache:=True;
LookUpKeyField:=NAME {Clients.db}
LookUpResultField:=NAME {Clients.db}
After that I start the form, but I can't edit anything in DBGrid field
NAME (there isn't drop down list)).

Help Me.

Philip

 
Jim Cate

Delphi Developer
Sun, 11 Feb 2001 03:00:00 GMT

Re:Help me with using LookUpFields in DBGrid


Philip
I think you will have to create a new lookup field using the fields editor
of TTable to achieve what you are after.
Jim Cater, Auckland, NZ
Quote
Philip Kirev wrote in message <35DD368D.CF240...@fintech.bg>...
>I have 2 tables TicketClients.db and Clients.db, field NAME is same in
>both and in TickeyClients.db is defined as lookup in Clients.db.
>In component TField {NAME in TicketClients.db} I defined:
>FieldKind:=fkLookUp
>KeyFields:=NAME {TicketClients.db}
>LookupDataset:=Table2 {Clients.db}
>LookUPCache:=True;
>LookUpKeyField:=NAME {Clients.db}
>LookUpResultField:=NAME {Clients.db}
>After that I start the form, but I can't edit anything in DBGrid field
>NAME (there isn't drop down list)).

>Help Me.

>Philip

Other Threads

1. DBGrid A table and 2 LookupField

2. DBGrid and Lookupfields

3. LookUpField in DBGrid

4. dbgrid-lookupfield

5. dbgrid-lookupfield-auto dropdown combobox

6. DBGrid and lookupfields

7. LookUpField And DBGrid

8. Using LookupFields in TTables

9. Help Using DBGrid

10. HELP - General Ledger using dbGrid