Proxy Fields

[BobWeaver]

The question sometimes comes up: How can the user select which fields appear on a layout without having access to layout mode. This can be easily done using calculated fields with the GetField() function or other similar means. But, the field can only be displayed; not edited.

This example shows a scriptless method of doing this using auto-enter formulae in the main fields and proxy (display) fields so that editing the proxy field will update the original field.

ProxyFields.fp7.zip

[mKirk]

Thanks for the example...I'm starting to catch on (a bit anyway). One question though. In your "Pick Field" layout you have the 3 global fields "gFieldSelect01..." formatted as pop-up menus. When I publish the example to the web, the pop-up menu functionality does not work. Is this an FM issue or other?

Thanks.

[BobWeaver]

I'm not sure. I've only just started using web publishing myself, so I'm no expert. However, I do have a web accessible database which works correctly with pop-up menus, but I've also found other things which don't work very well on the web.

The example I gave makes use of the FieldNames() design function to get the names of all fields, in order to create the value list for the pop-up. You might want to try creating a value list with fixed items. It's a lot simpler and less likely to have things to go wrong.