Global Field to store values from all records

[Matt Malyschko]

I want to have a global text field that is a list of all the values from separate records for a specific field.

 

Eg: say I have a table of Users, with field User ID.

 

I want a global text field UsersList to container the User ID from each record in the table.

 

Is there a way to do this without adding the values to the field via a script or something?

[comment]

Perhaps it would be better if you explained why you need this - then it would be easier to come up with the how.

 

In general, a global field is stored, so it will not necessarily automatically reflect all modifications to the referenced field.

[Matt Malyschko]

The reason is for this is to check availability of user names. I want to be able to check if the user name the person is typing is available in real-time.

[comment]

I want a global text field UsersList to container the User ID from each record in the table.

I want to be able to check if the user name the person is typing is available in real-time.

 

I am not sure what you mean by "available", or how would you do the checking.  Or how will a list of User IDs help in determining if a name is available. It sounds like you should define a value list based on the field, then use the ValueListItems() function - but with so few details I am merely guessing.