How do I update child keys when I update their string data?

  • Thread starter Thread starter Wade
  • Start date Start date
W

Wade

I'm new to VB .NET and I've made an Access database with several
one-to-many relationships. I want to display the data in a datagrid
and give users the ability to edit the database. It's simple enough
to import the database into a DataSet and display the string data that
the keys point to using SQL INNER JOIN statements, but once the data
has been updated, how do I use the new string data values to update
the child keys that need to be returned to the database? Do I need to
import the parent tables in their entirety and make a relational
dataset? If anyone could point me to some example code that would be
very helpful.
 
W.G. Ryan said:
If I understand you correctly, you don't want to use joins. Instead, pull
over two separate queries and link them with a DataRelation.
http://www.knowdotnet.com/articles/datarelation.html
Then you can call Update on each table/dataSet respectively.
Click to expand...

Thanks for the reply. That helped me structure my DataSet properly.
When I preview the data I can tell that it's all related the way it's
supposed to be, but it's kind of backwards from the way I want it,
i.e. right now each record in a parent table shows all the records
(which are in another table) containing its respective key, but I want
to look at that other table, in which each record contains several
child keys from several parent tables, and instead of seeing those key
numbers, I want to see the data from the parent table that the key
points to. This is probably an elementary issue, but I can't find how
to do it.
 
Back
Top