AnsweredAssumed Answered

Troubles with relationships creating records in other tables

Question asked by MichaelLoo on Oct 20, 2010
Latest reply on Oct 20, 2010 by philmodjunk

Title

Troubles with relationships creating records in other tables

Post

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?  

Outcomes