I need to create a Emergency contact list for all our employees and would like to use the data from Payroll. I am using ODBC to link to my Pastel Payroll information. I have linked to the EmployeeMaster for all the information that I need. The only information that I can not find is the Spouse contact details.
Is there anyone that know in which table I will find this information and what the field name is?