Troubles with relationships creating records in other tables
I am trying to make an a relationship that will help manage my asset database. They want it to be searchable by asset AND by employee. For example, I want to make it so that I can create an employee page showing all of the assets currently tied to him or her, but I want to be able to edit the asset directly, and switch out the asset's user on the fly.
However, my problem is that this isn't working as well as I thought it would. I created a table for a specific asset, like computer, and created a table with all the data in it called employee. I created a relationship between them, linking the fields with the same name, and turn on the "Create record" option. However, when I make an entry in the asset page, this record does not show up in the "employee" page. What am I doing wrong?