devxlogo

Using Multiple Data Control

Using Multiple Data Control

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.

See also  Redefining Energy Management: Advanced Solutions for Modern Buildings
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist