AnsweredAssumed Answered

How do I select a Parent record via a dropdown list?

Question asked by amyballew on Feb 26, 2014
Latest reply on Mar 3, 2014 by philmodjunk

Title

How do I select a Parent record via a dropdown list?

Post

     I need help figuring out how to link a child record to a parent record via a dropdown list.

     I have a parent table and a child table, with a one to many relationship defined via a primary key in the parent table and a foreign key in the child table.  

     I want to create a layout for child table instances and include a field from the parent table.  I want to be able to, for a given instance in the child table, to select a record in the parent table and create a link b/t the two records (in other words, store the primary key from the parent table in the foreign key field in the child table).

     It seems like this is a basic functionality, but I cannot see to figure out how to make it work.

     Help!

     Amy

Outcomes