Discussions

Expand all | Collapse all

Drop Down populated, value equals proxy field of related table, but isn't automatically updating

  • 1.  Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 14:42
    Trying to make a request form in an app. This involves airports, and I have an airport table that is related to the request table.

    I have a drop down named [Airport Name] which can be selected... Ideally, I want when this dropdown is selected, it automatically populated the [Related Airport] field and creates the relationship.

    I'm able to make it where the [Related Airport] is limited to just what matches [Airport Name] but it's not letting me just autopopulate.


  • 2.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 14:49
    Hi,
    In the relationship interface where you pull lookup fields from the Parent relation into the Child relation -- in the Child relation ( the right side ) you should have [Airport Name] as the proxy for [Related Airport]. Then, from the Parent side ( left side ) pull in lookup fields to the Child side. 

    When you select Airport Name in the Request form, you can use the Record Picker option wherein you can specify three fields. One of them can be the ID# of the Airport Name ( Related Airport).

    Add the lookup fields to the Request form. When you select your Airport Name, the lookup fields will auto-populate if there is information in the Airport table's records to pull. 





  • 3.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 14:55
    I'm unable to do that, may be because the requests is the many in the one to many relationship.

    I have the name field from the airport table, [Airport - Name], as the proxy field of the [Related Airport].

    I've even tried a dynamic form rule that would theoretically make [Airport - Name] equal the value in [Airport Name] which is natively on the Request table.


  • 4.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 15:08
    Yes, the relationship goes like this: Airports >> have many >> Requests. 

    I'm a little confused about what it is you're not able to do. Can you elaborate on that some?


  • 5.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 15:42
    I think I figured it out somewhat... I think the reason I was attempting to make the [Airport Name] it's own field and update the lookup field [Airport - Name] is because when I try to just use the reference proxy field, it's using the standard record picker, instead of a drop down, even with me having it set to show as a drop down.


  • 6.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 16:03
    Okay, so in Requests table, Airport Name is piped in via the relation, it s not its own field. 


  • 7.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 16:05
    At the moment... I have both... Airport Name is its own field, but then there's Airport - Name which is piped in via the relation...

    really what I'm looking for is one of these fields working as a drop down, and when that field is populated, the relation is populated.


  • 8.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 16:31
    Delete the Airport Name field that stands alone in the Requests table. Use only the Airport Name "Relationship". The proxy field [Airport Name] will serve as your drop down list. In the Requests table, open the Related Airport field properties. Set Airport Name as its proxy. Then you can use Airport Name as the drop down list. 


  • 9.  RE: Drop Down populated, value equals proxy field of related table, but isn't automatically updating

    Posted 09-26-2018 16:45
    Got it! I think I've also been battling the fact that the limit of a drop down list is 1000 records... My Airports table is 5500.