Issue while working with relational table

Swap7709 · Post by **Swap7709** » Fri Jun 21, 2019 3:08 pm

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?

arbei · Post by **arbei** » Fri Jun 21, 2019 3:17 pm

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.

Swap7709 · Post by **Swap7709** » Fri Jun 21, 2019 7:39 pm

Thanks, its working now