RogerCooper
Registered User.
- Local time
- Yesterday, 16:36
- Joined
- Jul 30, 2014
- Messages
- 288
I need to allow users to see a datasheet format an editable query with nearly 100 fields (it describes every possible piece of information about the products we sell).
I need for the users to be able to edit some fields, while locking other fields. The users need to be able to see more than 1 record at a time (there are often groups of products with similar data).
When I create datasheet style form, I run into the maximum width limitation after a dozen fields are displayed. If I show the raw query, I can't prevent editing of some fields.
Is there a way to meet the requirements.
I need for the users to be able to edit some fields, while locking other fields. The users need to be able to see more than 1 record at a time (there are often groups of products with similar data).
When I create datasheet style form, I run into the maximum width limitation after a dozen fields are displayed. If I show the raw query, I can't prevent editing of some fields.
Is there a way to meet the requirements.