AnsweredAssumed Answered

Table Relationships and Auto-Enter

Question asked by addison on May 17, 2016
Latest reply on May 18, 2016 by addison

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.