• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 251
  • Last Modified:

Visual Studio 2005, Visual Basic, One DataSource, Two tables

I have one DataSource (SQL SERVER), with two tables, (Employee and Address).  I have a form that pulls data from both, however, when I click through using the next record, only the Employee data refreshes, the Address does not, seems like the link is not working.  I do have them Relationship set on SSN.
0
ourguru
Asked:
ourguru
  • 2
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
let see your code
0
 
ourguruAuthor Commented:
Sorry, too new to this, how/what do you want me to show you?
0
 
ElrondCTCommented:
It would be helpful to see:

1) How you are connecting to the two tables and creating the relationship between them
2) How you move from one record to the next
0
 
ElrondCTCommented:
For future reference, if you solve your problem yourself, you can get a refund of your points. Thanks for the points, but I don't feel like I did much of anything, unless you realized from my questions that you hadn't done something you needed to do.
0
 
ourguruAuthor Commented:
Your info is/was appreciated.

Thanks
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now