Display a List collector on a catalog Item, based on a list collector on the back end

[jonathangilbert]

Hi There,

Is it possible to have a list collector on a Cat Item that is pre populated with data from a List collector on the locations table. 

I want to be able to display a list on the Portal of the users that have access in a certain site location, which is maintained on the locations table using a list collector.

For example SITE A on the locations table has a list collector of users with access to the site, containing User 1, User 2 and User 3.

If the manager of SITE A goes on to the Cat Item, I want the variable to show them the list of user with access prepopulated with User 1, User 2 and User 3

The list collector name on the cmm_location table is called "u_store_named_account_colleagues"

The variable list collector name on my cat item is called "colleagues_with_access"

Many Thanks in advance

[Brad Bowman]

The second part should be easy enough with a reference qualifier that calls a Script Include to query the location table and return value from that custom field.  The part I'm not following is that usually this is done when a previous variable value is set - so someone would choose SITE A, then the list collector would update to only show those users.  Are you not wanting this based on another variable value, rather if the current user is the Manager of any location?  Is manager a field you added to your location table?