Asp.Net 2013 Vol 1.

CLR 4.5

Situation:

WebHierarchicalDataGrid with datasource "well" defined.

I have Two tables

The first table contains an ID used by the second as a reference

(typically, the first table is the company and the second table is a site of the company and of course, the site table contains a CompanyID field).

Data are very well displayed.

Editing is allowed.

when I edited a row, everything works fine.

When I want to add a row, the CompanyID is not automatically set so there is an SQL error saying the field is empty. If a put the value of the CompanyID

in the field, the insert works fine. 

So the question is simple : What do I have to do in order to make the filling of this field automatically ? 

Thanks