Views: 4 Size: 404.0 KB">Database1.accdb
In the attached database there are two tables, tblUser and tblTime.
When the operator is selected within tblTime, I would like the ContractedHours field to change relevant to the fixed data in tblUser.
For examble tblUser has the UserLogin of Ollie, with a ContractedHours value of 8:00.
When Ollie is selected in tblTime, I would like the ContractedHours field in this table to also display 8:00.
Any help is massively appreciated!