I've problem with DBGrid
- From: "Bpk. Adi Wira Kusuma" <adi_wira_kusuma@xxxxxxxxxxxx>
- Date: Mon, 12 Nov 2007 21:26:37 +0700
I use D6, SQL Server 2000.
I have 2 tables with the structur :
CREATE TABLE T1 (
IDBRG INT PRIMARY KEY,
CODE VARCHAR(5),
Name VARCHAR(50)
);
// field Code is indexed unique
CREATE TABLE T2 (
NOTA VARCHAR(3),
IDBRG INT,
JML TINYINT,
PRIMARY KEY(NOTA,IDBRG)
);
Now, I make a form to enter data to table T2. On the form, I use DBGrid. I
want to make layout in dbgrid like it:
NOTA CODE Name JML
------- -------- ------ -------
So, user can only enter/type data on column NOTA,CODE,JML. Because column
NAMA will filled automatically when user enter CODE by right (there is on
table T1). Now, if I make field CODE as lookup field (FieldKind =fkLookUp),
So user can not type data, but has to choice item in list.
How to make an interface so user can enter data by typing? Any help to solve
it? I hope the solution "Dont use special component"
thx
.
- Prev by Date: Re: Open DBF with ADO via Delphi
- Next by Date: TADOQuery1.Properties['Update Criteria'].Value - Propertiesis nil
- Previous by thread: Open DBF with ADO via Delphi
- Next by thread: TADOQuery1.Properties['Update Criteria'].Value - Propertiesis nil
- Index(es):