I have Users as a Table (Emp Id, Emp Name). In Transaction table, i just want them to enter Emp Id first and then system will fetch their name from “Users” table. In transaction table, the field name “Emp Id”, added “Users[Emp Id]” as valid if. But system shows up the information as drop down. I just want as a text box where they need to input the Id. If Id is not in the “Users” table, then system can show error message.
Can you please help me out in this regard?