Value list from a variable

[gowrann]

I have a db of employees they have a location field in their record (this is a value list of different locations) - how would I make a value list automatically of employees who are at "location x"

[stanley]

I'm not sure exactly what you want to do with this, and there are a number of ways to do it, depending on your purpose. Here's an example, anyway:

1. create a relationship, LocationRelationship between Location and Location

2. create a text field called RelatedEmployee

3. create a value list, RelatedEmployees, and set it to use values from your related file (LocationRelationship:Employee Name (or whatever field you want the list to show)).

4. Format the RelatedEmployee field to be a pop-up list, using the RelatedEmployees value list.

What you end up with isn't functional for anything other than selecting another employee with the same location. You could, alternately, put a portal in, showing the related Employee Name data, allowing you to scroll through the list. Like I said at the start, it all depends on what you want to do with the data...

-Stanley

[gowrann]

Perfect!!! Thanks