TADOTable and Lookup fields

Thread View: borland.public.cppbuilder.database.ado

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Esther Mann Tue, 18 Oct 2005 15:05

#614

Author: Esther Mann
Date: Tue, 18 Oct 2005 15:05

26 lines
1682 bytes

Hi, I am using BCB6.  I created a TADOTable and then added a Lookup field

TADOTable tblClientTrans

KeyField - TransID
Field - ClientID (foreign key)
LookupField - ClientLookup

TADOTable tblClient

KeyField - ClientID
Field - ClientName

I add a lookup field to my client table which finds the client Name and 
displays it in the tblClientTrans table.  Now on my form I create a 
TDBComboBox called cboClient and set the Datasource to tblClientTrans 
and the Field to ClientLookup.  Then I drop that TDBComboBox on a 
TDBCtrGrid with it's datasource set to tblClientTrans.  All the data 
displays fine at design time.

At runtime, I get an EDatabaseError cboClient Field:'ClientLookup' not found

What is the problem?

Thanks in Advance
Esther Mann

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads