Hello,
I have run into a problem when using OpenAccessDataSource inserting/updating foreignkeys.
I am using a formview with an OpenAccessDataSource to insert and edit my data. The entity that I am editing is called Employee.
Employee has one foreignkey realtion to another entity called EmployeeGroup. I want to use RadComboBox in the formview to tie an employee to an employeegroup.
If using a SQLDataSource control you can simply do the following SelectedValue='<%# Bind("EmployeeGroupID") %>'. I have tried using the SelectedValue='<%# Bind("EmployeeGroup.EmployeeGroupID") %>' when using the an OpenAccessDataSource and I get an exception. The exception says:
{"Concurrent update detection failed because property 'EmployeeGroup.EmployeeGroupID' is not an accessible on type 'IntranetDataAccess.Employee'."}
Is there a way to handle this?
Any help is greatly appreciated
Here is my full code