Question:
I have two Data controls on a form, Data1 and Data2, both with data bound text boxes on the form, linked to them. Based on a common field (also the primary index in both recordsets), I need to set up a one-to-many relationship. For example:Data1.Recordset.Fields(“Code”) value is ‘123’I then need to show only the records in Data2.Recordset that have the value of ‘123’ in the Code field (usually about 4 records). Is it possible to do this with the data control or do I have to use another method?
Answer:
Each time you change values in the first data control, set the RecordSourceproperty to a new SQL statement, such as “SELECT field FROM * WHERE field = ” & value You may have to do a refresh on the data control when you change theRecordsource, but it will then show the relevant data in the bound control.