www.hkvforums.com

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?

Double check your Edit Tag settings and make sure you have set up lookup table for the foreign key field and it is not set as "TEXT" or you are using AutoSuggest with the textbox.

Thanks, its working now