-
I am trying to get a DataGrid to display the Child portion of a RecordSet (The Parent information is displayed in labelled textboxes above; they are linked through a common field, which are also linked in the Access database).
The problem is, whenever I test the application the DataGrid either displays the data from the Parent fields of the RecordSet or remains blank. I don't think the problem is with the SQL:
SHAPE { select ComponentNumber,FireZone, PIDLocation,PIDNumber,SystemNumber,Comments from Component Order by Component Number } AS ParentCMD APPEND({ selectDeviceNumber, ComponentNumber, Location, Coments from Device Order by DeviceNumber } AS ChildCMD RELATE ComponentNumber TO ComponentNumber ) AS ChildCMD
The Code for the DataGrid is:
Private Sub Form_Load()
Set grdDataGrid.DataSource = datPrimaryRS.Recordset("ChildCMD").UnderlyingValue
End Sub
Any advice?
TIA,
Jonathan
------------------
"Black?"
"For over thirty years."
-
Never mind. I left for lunch, and when I came back that part of the app was working fine. Sorry for the clutter.
Thanks,
Jonathan