I decided to create a new clean app to avoid propagating some of the learning mess I'd had in my first app. However I'm having issues with the record ID instead of proxy field showing up, as below;
I've checked back to my original app (where the lookup worked fine) and I cannot see any differences in the settings.
The related site field settings are as below;
I haven't copied in the screenshots of the original apps table relationships but they are exactly the same (unless I've been staring at these long enough that I can't see the differences!).
Thank you! I knew it was going to be in a menu I hadn't looked at yet :)
Are the record picker fields created when you create the table for the first time or the relationship for the first time? Just wondering if there is a default period when you can first chose these pickers to avoid having to edit later.
I did that one but by creating new "main" reports (since I wanted to leave the ALL reports alone) and then assigning these main reports as the default report, but thank you for the official method of doing this, less clicks in the future!
One other quick one, normally you edit the field value to remove the, for example, <add a new site> option (via "allow users to create new choices") but I can't remember where this option is for lookup fields? I'm pretty certain that also includes what information to display in the drop down (ie. record ID# + site ID or just site ID). I've been hunting but can't remember where this option is, can you point me the right way?
Got it, thanks!
And can you remember where the settings are for adjusting what's displaying in the dropdown choices? ie. record ID# + site ID or just site ID