AnsweredAssumed Answered

Help with my value list

Question asked by MarcoV on May 31, 2013
Latest reply on May 31, 2013 by MarcoV

Hi I'm having problems with a value list. Here's the scenario: I've got 2 tables:

Projects and Resources (Staff) which are related on Project No.

A project can have numerous resources, these are added by using a User ID.

(When the user logs onto the system their User ID is stored.)

I have a Timesheet table which allows the current user to enter what projects they've been working on.

 

 

Objective:

I want a drop down list to show only Projects that have a Status = "Approved" and End Date < today and where the current user is a Resource. So the user can only select valid projects.

 

Simple?

Outcomes