AnsweredAssumed Answered

Self Joining Relationships and Drop Down Menus

Question asked by JanineAntoni on Aug 5, 2015
Latest reply on Aug 6, 2015 by philmodjunk

Title

Self Joining Relationships and Drop Down Menus

Post

I am looking to have fields in a drop down menu prompt new fields to appear on my database. I believe I need to make a self-joining relationship but I am not sure. Can someone help? I am trying to keep track of objects in this database. The drop down menu is be 'Current Location' and is comprised of a list including 'Studio,' 'On View in an Exhibition,' 'Gallery.' When something like 'On View in an Exhibition' is chosen, I would like it to prompt a field to show up asking  'Exhibition Name' and another asking 'Expected Return Date.' Is this possible? Help please!

 

Outcomes