First, If I am posting in the wrong place please let me know. I am newbie with filemaker and really don't know where to go.

I have an existing database where I track jobs/job numbers, time put against them etc. Currently when I create a new record in my Jobs table, the associated number is trasfered to the time sheet table, in a drop down menu, for my staff to choose from to enter time against. What I would like to be abe to do (ina simple way) is to create a field on the Job table, so that when data is entered (or it could be a check box), the associated job number is removed from that drop down menu on the time sheet table, so that when a job is complete, time can no longer be put against it.

Does that make sense? If so, can it be done?

Thanks!!!

Hello K.,

This is more of a value list question, if i understand you correctly. To paraphrase, as I am not sure I get the picture, you want a value omitted from a value list in a drop down menu, when certain criteria is fulfilled.

You can accomplish this by setting up a value list in the Time Sheet which draws its values from related records in the jobs table. The relationship should use a constant (say a global "1") on the Time Sheet side, and a calculation field on the Job table side, which delivers "1" if the Job hasn't been completed. In the "Specify Fields for Value List" dialog box make sure you are starting (the bottom left selection) from a relationship that will show all values. A relationship that ties the Time Sheet global "1" equal to a Job table auto-enter "1" field will do it.

HTH

Biti

I hat to be such a newbie, but I dont quite nknow what you are saying. I have a value list for my job numbers on the time sheet table...it is populated by it's relashionship is with the Job number field on the Jobs table...I am just not sure what you mean by "relationship sould use a constatn say a global "1"?

Also as an FYI, I didn't build this database, I am just altering it, so forgive my ignorance.

Kim

Create a calculation field (or auto-enter calculation text field with 'do not replace existing value' deselected) of

If( JobStatus <> "complete"; JobNumber )

and use this calculation for your value list instead of the JobNumber field.

Or, create a calculation text field in your TimeSheet table equal to "complete". Then create a new relationship with the criterion

TimeSheet::CalcComplete <> Jobs::JobStatus

and set your value list to use Jobs::JobNumber, starting from the new relationship from TimeSheet.