I have two tables Department (deptId[primary key], deptName) And Employee (EmpId[primary key], EmpName,deptId[foreign key references deptId from DepartmentTable])
When I generate the code and try to add Employee The department Id field is shown as text box,
What I expect is the values from Department Id/Name are shown in drop-down / multi select list on Add Employee form, As it is basic requirement,
Is it possible in current version? Is there any settings I need to change in order to achieve this?
Issue while working with relational table
-
- User
- Posts: 3