List field no looking up details

Hi Paul,

1000 records in a list field is a maximum that is set in the CMS code.  It is possible to customize the code to remove this restraint, but it is definitely not recommended.  The best solution would be to look for ways to minimize the number of records that would need to appear in the list, as a list of 1000 or more is difficult to use or manage.

There are a few ways to minimize this list depending on the type of list you are using.  For example, say you have a list of 1500 products that you want in a list and each product has a category.  You can create a category list field first.  Selecting a category from that list can trigger an update in the product list to only show products of the selected category.

Does it sound like something like this would work for you?

Please let me know if you have any other questions.

Thanks!

Hi Jason,

Thanks for the reply.  In this instance it's not really possible to filter the list based on other parameters, the table in question is storing customer enquiries and there's a list field on this table for 'Customer' which refers to the customer table where there are 1500 customers.

Are you able to point me in the direction of the 1000 limit within the code or is it in a lot of places?  We don't anticipate the customer database growing much more now so even if I could increase the limit to 2000 then that would solve the problem.

Thanks, Paul.

Thanks Greg, that works perfectly.

Regards, Paul.