After insert in details table the record, updated this with values of link fields from value of Master table record, execute post on detail table and refresh table beacause for commit changes and after that refresh on grid table of detail grid1.refresh.
Adrian Popa ([EMAIL PROTECTED]) --- In [email protected], "Alex Oentoro" <[EMAIL PROTECTED]> wrote: > > I've already done it before, but the result still the same > > procedure TForm1.TDetailNewRecord(DataSet: TDataSet); > begin > With TDetail do > begin > FieldValues['TNo'] := TMaster.FieldValues ['TNo']; > FieldByName('TUrut').AsInteger := RecordCount + 1; > FieldByName('TQty').AsInteger := 0; > FieldByName('THrg').AsInteger := 0; > FieldByName('TSubTot').AsInteger:= 0; > end; > end; > > On 2/6/07, Vishak <[EMAIL PROTECTED]> wrote: > > Hi, > > When you define a master-detail relationship between two datasets (tables, in your case), the detail dataset is filtered according to relationship field with master dataset. When you create a new record in detail dataset, please check if you are setting the value of this relation field according to current record in Master dataset. > > > > E.g. > > OnNewRecord of detail u can mention > > TDetail.FindField('TNo').AsString := TMaster.FindField ('TNo').AsString; > > > > HTH, > > regards, > > Vishak > > ---------------------------------------------------- > > ----- Original Message ----- > > From: Alex Oentoro > > To: [email protected] > > Sent: Tuesday, February 06, 2007 9:44 AM > > Subject: [delphi-en] problem about ADOTable+Grid > > > > > > Hi, > > i have a question about master-detail connection using TADOTable & Grid > > > > I put 2 ADOTable in 1 form : > > TMaster : Primary Key : TNo > > TNo char(10) > > TTgl date > > TCust char (25) > > > > TDetail : Primary Key : TNo, TUrut > > TNo char(10) > > TUrut byte > > TBarang char(25) > > THrg integer > > TQty integer > > TSubTot integer > > > > TMaster & TDetail connected via MasterSource property of TDetail > > > > each table connected to separate Grid > > > > the Problem occurs on the detail grid. Everytime I enter more than 1 > > row, detail for the previous row become disappear. But after the > > Transaction is saved, all data rows suddenly appear. > > eq : I enter 1 row on detail, and then press down key to enter data > > for 2nd row on the grid ... then 1st row is disappear. Same thing > > happened when I press down once more to enter the 3rd data, so at one > > time there is only 1 row appear in the detail grid > > > > what should I do to make all rows always appear when I enter more than > > 1 row of data ? > > > > thx in advance. >
