ParrotHead72
-
Posts
1 -
Joined
-
Last visited
ParrotHead72's Achievements
Newbie (1/14)
0
Reputation
-
Populate cell from another table value
ParrotHead72 posted a question in Tables, Views and Relationships
I have 2 Tables: Computers and Users. In the Computers table, i have information of SerialNumber, CPU, RAM, OS, Model, and IssuedTo. In the Users table, i have information of FirstName, LastName, FullName,... and AssignedComputer. What I would like is when I populate the IssuedTo field in the Computer table with a user's FullName, I would like it to auto populate the SerialNumber in the AssignedComputer field of the User table. How do I link them?