I have a field of "Active Jobs" that's coming from another file through a relationship. When a user goes into the "Time" file to add time to a job he clicks on the "Job Number" field and gets a list of the active jobs. Cool! This works fine. But when you go into find mode and click on the same field it does not give you the list.

Any ideas?

What relationship should it use while in Find mode?

Since you are no longer on a record, how can FMP resolve the relationship?

You will need to setup another value list that is NOT based on related values, or based on a relationship that is built from a global field on the left side of the relationship.