AnsweredAssumed Answered

Auto-fill one field from another

Question asked by nathanrewbury on Sep 30, 2016
Latest reply on Sep 30, 2016 by scottworld



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.