SchoolTeacher54
asked on
Synchronizing two data sets
I am transitioning from VB6 to VB.net. Enough of that...
For verification sake I want to confirm best practices.
1. I have two forms sharing a common dataset from an Access 2013 database. Form1 uses the table "contacts" and form2 uses the table "notes". They both share a common field "contactID"
2. My thinking is that when I open Form2 (notes) to update any notes to be stored from the open contact from Form1, I can just insert a parameter into the query searching the common 'contactID'. If there are no records found I can create stub record using the contact ID. If the user changes their mind, an update will not be called.
We all know there are hugely conflicting opinions on every issue possible on the internet. I've read some articles that believe this is the dumbest thing they've ever heard of and others that think it's just fine. I hate doing things twice.
Question:
1. Is this best (or acceptable) practice?
2. If not best or acceptable can I get some guidance on what would be?
Many thanks
For verification sake I want to confirm best practices.
1. I have two forms sharing a common dataset from an Access 2013 database. Form1 uses the table "contacts" and form2 uses the table "notes". They both share a common field "contactID"
2. My thinking is that when I open Form2 (notes) to update any notes to be stored from the open contact from Form1, I can just insert a parameter into the query searching the common 'contactID'. If there are no records found I can create stub record using the contact ID. If the user changes their mind, an update will not be called.
We all know there are hugely conflicting opinions on every issue possible on the internet. I've read some articles that believe this is the dumbest thing they've ever heard of and others that think it's just fine. I hate doing things twice.
Question:
1. Is this best (or acceptable) practice?
2. If not best or acceptable can I get some guidance on what would be?
Many thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yeah, in Access there's at least five ways to get anything done, and it's often hard to tell which one is best!
ASKER
You understood the question. My brain really got bent by some of the articles that I read as if there is some magic going on with .net.
I'll carry on feeling better about the whole thing now. Thank you.
Scott