I have 2 tables one called tb_employeemaster and the other tb_prefix.
In the tb_employeemaster
- I have 4 fields ID, ee_number, ee_prefix, ee_name. where ID is Primary and ee_number is Index.
In the tb_prefix
- I have 2 fields, ID, tb_description, Where ID is Primary (the prefix is Mr., Ms, Mrs etc)
I now want to create an New Employee form created from tb_employeemaster. In this form I would like to be able to call the tb_prefix field tb_description into a pull down menu.
Please let me know if that is possible.
Thanks