AnsweredAssumed Answered

Creating NEW records in Join table using data from other two tables in many to many relationship

Question asked by KatherineGold on Mar 16, 2012
Latest reply on Mar 21, 2012 by KatherineGold

Title

Creating NEW records in Join table using data from other two tables in many to many relationship

Post

Created many to many relationship with these three tables: Users - Assignments (Join) - Keys.  I have set up: User::UserID=Assignments (Join)::UserID//enable "Allow creation of records via this relationship" for Assignments
Keys::KeysID=Assignments (Join)::KeysID//enable "allow creation of records via this relationship" for Assignments.  When I add a portal on the User layout and a drop down menu to select a key number from the "Keys" table, I don't see any records.  I see how this works for value lists, but not for tables.  I did set some fields as "look ups" like "LastName", but it is not working.

My goal is to:

1.  Create new records in the Assignments (Join) table by selecting the user name from the User table and the key code from the Key table.  They are related on the relationship graph

2.  Then complete other aspects of the key Assignment like issue date, etc.

Can anyone help me through this?  Thank you --- kgold

Outcomes