Hi eveyone,
I have a shape command that returns master detail records. I have 2 datagrids on my form. Datagrid1 is looking at the recordset `adoPrimaryRS`
and datagrid2 is looking at the recordset ` adoPrimaryRS("Child").value.
When I click in datagrid1 all the corresponding details appear in datagrid2.
Ok now for the hard part!. I have 2 textboxes on my form Text1 and Text2.
Text1.Datasource = adoPrimaryRS
Text1.Datafield = "MasterId"
When I scroll through my master records the container field is shown in Text box1 and shows the field name ok.
- Text2.Datasource = adoPrimaryRS("Child").value
Text2.Datafield = "DetailId"

When I run the form and click on a record in my master datagrid the Text1 shows the field name ok, if i scroll through the records the Text1 field also updates. Whay I am findig though is if there are more than 2 detail records, even if I click the relevant records in my detail datagrid2 only the first record from my detail shows in the Text2 field "detail" and this field will not update when I scroll through datagrid2.
This is driving me mad as I am sure there is a very simple explination to my problem.
I would really appreciate some help.
Thanks in advance.
Franki