dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


Tip of the Day
Language: Visual Basic
Expertise: Beginner
Jul 24, 1997

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


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 RecordSource property 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 the Recordsource, but it will then show the relevant data in the bound control.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date