I need to create a pop-up list based on a table. My problem is I need
this list to contain only 'active' items which are based on a field.

i.e. I need a pop-up list of active jobs, based on a table of all
jobs.

You have a field (MyItems)
Create a field IsActive, containing a 1 or zero (simple checkbox will do)
Create a calculation field MyExport [ if(IsActive);MyItems;"")

use the MyExport field for your value list.

-- 
Keep Well,
Ursus


"Dean" <deanjlee@gmail.com> schreef in bericht 
news:563150c1.0412140038.4be72332@posting.google.com...
>I need to create a pop-up list based on a table. My problem is I need
> this list to contain only 'active' items which are based on a field.
>
> i.e. I need a pop-up list of active jobs, based on a table of all
> jobs. 

"Dean" wrote:

> I need to create a pop-up list based on a table. My problem is I need
> this list to contain only 'active' items which are based on a field.
> 
> i.e. I need a pop-up list of active jobs, based on a table of all
> jobs.

I am assuming you have a field called isActive that flags a job as active or
not active.
Create a calc field that copies the data only if the job is active:
Activejoblist (if (isActive = "yes", jobname, "")
Base your value list on the activejoblist field, which will contain the job
name for only those records that are active.

There is probably a more elegant solution using relationships and portals if
you wanted to go that route.

Geoff