Please show me.
Once I have selected the table Competitions from which the winners are selected from the list, I cannot select the Players columns for the action where I could make the handicap deduction. Only relational fields are displayed in the table.
Relations to Field table work.
The tricky thing is that I donât know which columns I can get the relationship between players and competitions ? Players in the table names are standard, but competitions in the table can only have some of the names.
Which component is that action attached to?
It should be an Item Click action on a Collection that has the Players table as the source, in which case all columns in the Players table should be available for Increment and Set Column Values actions.
The button âFix handicapsâ contains the function to reduce the handicap reading. The starting table is Players so I can select a handicap column, but I canât select a condition from the Competitors table for race winners. Or if I put Competitions as the table, I canât select players from the table column.
Yeah, see thatâs the problem. From the Button you wonât have access to the columns in the Players table. As I said, the action needs to be on the Players Collection as an Item click, and you need to click them one by one. If you set it up correctly, then as you click each player in the list, their handicap will be adjusted and their name will be removed from the list.
Also, I notice that you are doing this inside an Edit Form - why?
Iâm not exactly sure if that will work. It probably will, but there should be no reason at all to do this inside an Edit Form.
OK, I get it. I figured if I could get a reasonable relationship between those Players and Competitions table, it would work. Toi Edit Form has become âaccidentalâ. Iâve started building an app that I hadnât heard of this glide at all, so I was building that app so I didnât think so much about what format I was in, as long as I could get it working 