vb-Database-Master/Detail
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.
Re: vb-Database-Master/Detail
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