Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
1139
SQL Saving Child grid entries
posted

My grid looks something like this...

Parcels
      Parcel Details
      Parcel Notes.

The notes row is the only row that's editable.  Notes can be added and edited, but not deleted.

Everything is working just fine, I can edit notes all day, but ADD is the problem.  But to be a valid note, the Parent Parcel ID must be used in the stored procedure to identify the parcel attached to the note.

How do I get the parcel ID on inserting a new row. 

Or, could I handle the updating with code, and if so, how do I do that?