Originally Posted by
gwboolean
It was partially answered. Had the answer been complete it would have included some information about how that method is called and used. As far as constrains, I set nothing up. All I did was set a relationship between the foreign key in the table tblDocMaster, child table to the Primary key in tblChangeRequest. parent table. I checked the relationship in the tableadapters and it is set to relationship only.
I did notice that there was no tableadapter for the parent table in the form properties and put that in then called the fill query (or method) in the load event (both tables should now be open. However, the record in the child table still threw the exception when the query was called using the parameter value that specifies that record.
I am wary of just going to a method, GetData, that I am unfamiliar with and am able to obtain no useful information about. I would prefer to use the method I am currently using, if possible. I would like to understand why the method I am using is throwing an exception for one particular record and not others?