|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2005, 08:10 PM
|
|||
|
|||
List Conditions
I'm creating a timesheet form and want to be able to populate a list of job
codes specifically by client. For example, in the "Client" Column you select Client X from a list. The "Job Code" Column would then produce the drop down list specifically related to Client X. If in the "Client" Column I selected Client Y, the "Job Code" Column would then produce the specific job codes related to Client Y. There may be a much simpler alternative- any help would be appreciated. 
|
|
#2
September 15th, 2005, 08:15 PM
|
|||
|
|||
|
I'm creating a timesheet form and want to be able to populate a list of job
codes specifically by client. For example, in the Client Column you select Client X from a list. The Job Code Column would then produce the drop down list specifically related to Client X. If in the Client Column I selected Client Y, the Job Code Column would then produce the specific job codes related to Client Y. There may be a much simpler alternative- any help would be appreciated.
|
|
#3
September 15th, 2005, 09:27 PM
|
|||
|
|||
|
Check Debra Dalgiesh's site
http://www.contextures.com/xlDataVal02.html It has just what you need "Kate" wrote: I'm creating a timesheet form and want to be able to populate a list of job codes specifically by client. For example, in the Client Column you select Client X from a list. The Job Code Column would then produce the drop down list specifically related to Client X. If in the Client Column I selected Client Y, the Job Code Column would then produce the specific job codes related to Client Y. There may be a much simpler alternative- any help would be appreciated.
|
|
#4
September 15th, 2005, 09:55 PM
|
|||
|
|||
|
This is fantastic- thank you!
"Duke Carey" wrote: Check Debra Dalgiesh's site http://www.contextures.com/xlDataVal02.html It has just what you need "Kate" wrote: I'm creating a timesheet form and want to be able to populate a list of job codes specifically by client. For example, in the Client Column you select Client X from a list. The Job Code Column would then produce the drop down list specifically related to Client X. If in the Client Column I selected Client Y, the Job Code Column would then produce the specific job codes related to Client Y. There may be a much simpler alternative- any help would be appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
| outlook 2003 public folders of custom list | Lynda | Contacts | 1 | June 9th, 2004 01:25 PM |
| finding & sorting unqiue names list | iwtci | Worksheet Functions | 6 | June 6th, 2004 06:43 AM |
| Find item in list by referencing two conditions | Cornelius | Worksheet Functions | 1 | March 10th, 2004 06:20 PM |
| How to make list of unique values? | JulieD | Worksheet Functions | 1 | February 26th, 2004 12:25 PM |
Linear Mode
