October 9, 200916 yr Newbies I have a drop-down list which users can edit and enter more values but I want to limit them to entering no more than 6 different values. Is there anyway I can limit the value list to having a maximum of 6 seperate values. I want to do this so that if users want to enter more than 6 values then they can pay for a slightly higher priced edition of the database. Any help is very welcome, sorry if I didn't explain very clearly.
October 9, 200916 yr Perhaps you could create a related table that contains 6 records and a field which will be referenced in the Value List. Set the Privileges for this table to 'Read' and 'Edit' but not 'Create' or 'Delete'.
Create an account or sign in to comment