Self Joining Relationships and Drop Down Menus
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!