TADOTable and Lookup fields

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

Article #614

Back to borland.public.cppbuilder.database.ado Previous Next

#614

From: 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

Technical Details

Message-ID: <43550ff5$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,9ae8b5756fd02734,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 18 Oct 2005 08:05:06 -0700
From: Esther Mann <esther@agencysoftware.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TADOTable and Lookup fields
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 207.88.115.45
Message-ID: <43550ff5$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1129648117 207.88.115.45 (18 Oct 2005 08:08:37 -0700)
Lines: 26
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!proxad.net!fr.ip.ndsoftware.net!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail