5 Replies Latest reply on Sep 30, 2016 8:02 AM by scottworld

    Auto-fill one field from another




      I have a table called 'Timesheet' and I want have a field auto-fill from records in another table 'Employee Directory'.


      I have a field in the 'Timesheet' table called 'Employee name' and once a name has been selected from the drop-down list (which I've already done) I want a field called 'Entitlement' to be automatically populated with the Entitlement information from the 'Employee Directory' table. Both 'Employee name' and 'Entitlement' are present in both the 'Timesheet' table and the 'Employee Directory'.


      Any help would be appreciated.