updating all columns vs updating select columns
I am using DataAssist with an updater page. Scenario: membership database where members can update most of their own information. However, some fields are just for the office (to mark as paid, new member, etc.) When using the updater by the member user, those fields' contents disappear. This is a database set up issue, I'm sure. I've tried sets, using 'y','n' and enum with '0','1' and experimented with Null and Not Null, but keep striking out. How can I keep the information intact and not let the member user change it?
Thanks!