1 Replies - 6479 Views - Last Post: 19 December 2012 - 07:06 AM Rate Topic: -----

#1 Vishal1419   User is offline

  • D.I.C Head

Reputation: 5
  • View blog
  • Posts: 142
  • Joined: 19-May 12

Add, Update, Delete in two tables having one-to-many relationship

Posted 14 December 2012 - 06:04 AM

Hello Everybody,
I have an access 2007 database called "dbExpenses"
I have two tables in this database named "tblExpenses" and "tblexpensesSub"
Attached Image
One-to-Many Relationship occurs between both the tables
and also Cascade Update and Cascade Delete are set to true
I have a form "frmExpenses" in my Project
Attached Image
Here there are variable no of rows which will be stored in the tblExpensesSub while there is only one row which will be stored in tblExpenses
I am very much confused about Add, Delete and Update in such Critical conditions
Note : The whole form is created dynamically
I have posted this topic on social.msdn.microsoft.com
There I got 1 reply saying that TableAdapterManager in vb.net is designed for my problem
Does anyone know how TableadapterManager is used, as there is not much data available on using tableAdapterManager with dynamically created controls
or If you have any other Ideas please Reply
Does anyone have idea about it?
Thanks in advance

Is This A Good Question/Topic? 0
  • +

Replies To: Add, Update, Delete in two tables having one-to-many relationship

#2 Vishal1419   User is offline

  • D.I.C Head

Reputation: 5
  • View blog
  • Posts: 142
  • Joined: 19-May 12

Re: Add, Update, Delete in two tables having one-to-many relationship

Posted 19 December 2012 - 07:06 AM

Is anybody there?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1