How do I select a Parent record via a dropdown list?
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.