I have setup basic actions on each of my database tables. Now, there are underlying relationships between the tables. For example, I have a 1 to many relationship of Deals to Properties. I create a deal using the basic creation action. Now, I'd like to be able to create a property and associate it to the deal.
The difficulty I'm having is that when the form is presented to create the property record, the deal ID text input is a free-form text input that requires me to lookup the deal ID. Is there a way to setup a custom action such that this input is instead a dropdown where I can select from a list of all the deal IDs?