Click to See Complete Forum and Search --> : vb-Database-Master/Detail


March 1st, 2000, 12:46 AM
I want to use Master-Detail form in my application.My detail form will have columns (for e.g QTY * PRICE as Extended Price )
which are not database-columns(,instead calculated-column);at the same time i want to enter the records directly in the detail form
displaying multiple records.Is it possible to use datagrid for this purpose?. Or is any other controls or techniques avilabe for the same purpose.
Thank U.

May 11th, 2000, 03:08 PM
Create a dynamic recordset:

Set rsDetail = New ADODB.Recordset
With rsDetail
.AddNew
'Insert Your Equivalent Database Fields
'For the computed or aggregated fields
.fields.append "TotAmt",adCurrency
End With

Set DataGrid1.DataSource=rsDetail