Forum Discussion

RyanStanford1's avatar
RyanStanford1
Qrew Captain
7 years ago

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

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... I...
Forms
Relationships
RyanStanford1's avatar
RyanStanford1
Qrew Captain
7 years ago
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.
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago
    Okay, so in Requests table, Airport Name is piped in via the relation, it s not its own field. 
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    7 years ago
    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.
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    7 years ago
    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. 
  • RyanStanford1's avatar
    RyanStanford1
    Qrew Captain
    7 years ago
    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.