REF ROWS question. Hi - I have 2 linked tables. Table 1 is a list of Fishing Trips, table 2 is a list of related Fishing Activities where a trip can have many activity rows.
I have 2 forms - one to add a new trip (which works fine) and another to add a Fishing Activity to a Fishing Trip.
For the second form, I want to be able to select from the list of Trips to add an activity to that trip. I can do this but the Reference Field (Trip_ID in the screenshot) defaults to a List of Vessel Names (PLN_Vessel_Name in teh screenshot) but I want it to display a list from a Virtual Column (a concatenation of Date and Vessel) Date_PLN_Short_Name in the screenshot.
So how can I get the linking column list to display a different list? Or is Appsheet smart enough for me just to use one form and if so what is the best way to do this?
Screenshot attached which may help - thanks in advance for any pointers or help James