Hello, I am working on creating a FMLA database using Access. We don't have one right now. So I am trying to pull all employees information from other tables which exists for various functions. For example, the tables are "PAEMPLOYEE, EMPLOYEE, PERSACTHST, PERSACTION, PERSACTYPE, TAEEMASTER, TAEMPTRANS, EMSTATUS, DEDCODE, DEPTCODE, EMPCODES". I want to know if any more tables needed to get the employees information to create FMLA database if so, what are those?
My second question is there any way to calculate FMLA accrued hours without manual calculation and usage time frame?
Third question, is there any way to interlink tables to get the required field without running a query?
Thanks for considering to help, I really appreciate your input.