I'm building a time card database (each record is a different time card). I have an Account field in the Time Cards table that auto-enters the record creator's account at the time of creation. This field cannot be overridden, and individual users can only view records that have their account in the Account field.
I have another table called Employees, where I want to store Account, First Name, Last Name, and ID Number. In this table, each record represents a different employee.
I want my Time Cards table to auto-enter the employee's first and last names, and ID number upon record creation. Basically, when an employee creates a record, the record should auto-enter their Account (which I've already figured out) and ALSO auto enter their name and ID in the appropriate fields.
I think I will probably have to create relationships between all these fields, but I don't know how to make the relationship dependent on one table or the other, so that it will pull the correct data from one table and display it in the other.