Working in FMP8, I have two tables, Jobs and Work, in a one to many
relationship. I want to have a drop-down list in the Work layout,
letting users select a job (entering the Job ID into the Work table);
I only want the active jobs to appear.

In Jobs, I have two calc fields, one which returns the job ID number
if 'JobArchived' = 0, and one which does the same thing with the job
name.

I have created a value list based on these two fields, which returns
the active jobs correctly sorted by job number, if I sort by the first
field (JobID). However, if I try to sort by the second field
(JobName), a seemingly random subset of the active records are
returned, not sorted by any discernable method. I've tried reverting
back and forth a few times, and it's always the same set of records.

Does anyone know what's happening? I'm thoroughly confused by this.

On May 30, 5:40 am, multiple... (AT) gmail (DOT) com wrote:
The good news is if its always the same set of records its not
'random'. Usually when this sort of behaviour crops up, its because
you've specified something through the wrong relationship, so its
finding or sorting the wrong record set.

Check your field defs, your relationship defs, your value list defs.
There's likely an incorrect reference somewhere.

Also, consider the Table Occurrence of the layout this is appearing
on, as that defines the perspective through which things are viewed.

I can't really be more specific as the problem description was vague.

-cheers,
Dave