Connecting 2 tables

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

yes you can. go to the ee_prefix field and scroll down until you find the lookup section. Check it and define your search criteria.