V
Vinod
Hi All,
I've create a table Employee, Emp_ID, Product, Comments Where Emp_ID and
Product are imposed with primarykey. i.e., combination of Emp_ID and Product
should not be duplicated.
I've designed a bound form with above said table display as contineuous form.
Header contains product drop down which is populated with master table.
If user selects any product in the top then assigning the product code in
details section with selected product through dropdown change event. If user
selects employe name Emp_ID automatically populated.
In this way I'm trying to add new record.
Giving employee name in first field, Emp_Id retrieved from antother table
based on given employee id, Product contain 'test' which I selected in
header. Till this record is in edit mode. After this I'm moving to second
record there I'm getting following error.
"Index or Primary key can not contain a Null Value".
Please help me how to resolve it.
Advanced Thanks,
~Vins
I've create a table Employee, Emp_ID, Product, Comments Where Emp_ID and
Product are imposed with primarykey. i.e., combination of Emp_ID and Product
should not be duplicated.
I've designed a bound form with above said table display as contineuous form.
Header contains product drop down which is populated with master table.
If user selects any product in the top then assigning the product code in
details section with selected product through dropdown change event. If user
selects employe name Emp_ID automatically populated.
In this way I'm trying to add new record.
Giving employee name in first field, Emp_Id retrieved from antother table
based on given employee id, Product contain 'test' which I selected in
header. Till this record is in edit mode. After this I'm moving to second
record there I'm getting following error.
"Index or Primary key can not contain a Null Value".
Please help me how to resolve it.
Advanced Thanks,
~Vins