Can you prefill DataGrid footer template fields

[pbeeke]

Can you prefill DataGrid footer template fieldswith items from the same datagrid. For example I am using the footer template in the grid in order to add a new record. THe query that updates the record needs a primary key and an employee number - both of which appear on every row in the datagrid. Does anyone know how I can prefill these two footer fields.

Thanks

[nateraaaa]

Can you prefill DataGrid footer template fieldswith items from the same datagrid. For example I am using the footer template in the grid in order to add a new record. THe query that updates the record needs a primary key and an employee number - both of which appear on every row in the datagrid. Does anyone know how I can prefill these two footer fields.

Thanks

Are you inserting into the database or updating a record in the database? You say that you are adding a new record but calling an Update query. Shouldn't you be calling an Insert query? Does your insert query create a primary key and take the employee number as a parameter? Please provide more details.

Nathan

[pbeeke]

Sorry Nathan yes you are right I am inserting not updating and yes one of the fields that I want to prefill is the primary key [project_ID] and [emp_no] which is a required paramater needed for the insert.

Thanks in advance