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.
1. Is this best (or acceptable) practice?
2. If not best or acceptable can I get some guidance on what would be?