Limit in related table lookup?

Hi Rob,

I took a look into this and I learned something new about CMS Builder! :)

It turns out that cms builder imposes a limit on the number of options that can appear in a drop down list. By default, this limit is set to 999, which is why some of your options don't appear.

There are a couple of ways you can approach this. If your records are being populated by a front end form and not manually through CMS Builder, then this limit won't make any difference for you. The :label pseudo field will still get populated. So you could output the customer name like this:

<?php echo $record['customer:label'];?>

Take a look at the test page you put up to see this in action.

The other option would be to increase the limit from 999 to something greater. This can be done in cmsAdmin/lib/database_functions.php

In the function getListOptionsFromSchema() you'll see a line that looks like this:

$query = "SELECT `$valueField`, `$labelField` FROM `$selectTable` $where $orderBy LIMIT 0, 999";

You could increase this if you want. This is not the best option, however. If you get sufficiently large lists, you could slow down your page trying to load all the records. Also, since this would be a custom change, it would be overwritten as soon as you upgraded your version of CMS Builder. I would recommend using the customer:label option.

Hope this helps.