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


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

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
Thanks for your registration, follow us on our social networks to keep up-to-date