A little more information.....I have now tried this:
{af_hotels:optional,form_page,form=hotels,label=Hotels}
....which works and provides an unfiltered list of hotels in the combo/dropdown box. However, why is my where clause returning no rows?
,where=ht_iata_code='MCO',
As a result I now have another question! With the above shown formfield specicifation, it is the _title field that appears in the dropdown. Is it possible to specify a different field to be displayed (i.e. in this example the IATA code field)?
In this example, it would in fact make more sense to have a selector in the 'hotels' form that allowed the selection of an airfield, instead of the other way around. However, if I do that I would want to list the ICAO codes rather than the airfield names stored in the _title field.
I hope this makes sense?
What an immensely powerful tool this is! 😊
Regards
Richard