J
Jeffrey K. Ries
I think I may have fizzled my brain stem. Can someone help me??
I have two tables 'Phase Codes' and 'Task Codes'. I have shown a simplified
excerpt of the 'Task Codes' table below.
Task Code Phase = S Phase = C
ADD [X] [ ]
AWD [ ] [X]
ASM [X] [X]
BID [ ] [ ]
I have a form with two combo boxes - one for each code. What I am
attempting to do is to have the first combo box (Phase Code) filter the
results of the second combo box (Task Code). Any one project has a Task
Code and a Phase Code. The Phase Code is a simple one letter code such as
"S" or "C", while a Task Code is a three letter code. There are only six
phase codes, but there are dozens on Task codes so I would like to filter
them through a query.
I have tried many, many variations but none work correctly. I am afraid
that I am thinking about this all wrong so I am intentionally omiting the
querys I have tried so far. If requsted I can provide this.
How would one of you attempt this?
Thank you,
Jeffrey K. Ries
I have two tables 'Phase Codes' and 'Task Codes'. I have shown a simplified
excerpt of the 'Task Codes' table below.
Task Code Phase = S Phase = C
ADD [X] [ ]
AWD [ ] [X]
ASM [X] [X]
BID [ ] [ ]
I have a form with two combo boxes - one for each code. What I am
attempting to do is to have the first combo box (Phase Code) filter the
results of the second combo box (Task Code). Any one project has a Task
Code and a Phase Code. The Phase Code is a simple one letter code such as
"S" or "C", while a Task Code is a three letter code. There are only six
phase codes, but there are dozens on Task codes so I would like to filter
them through a query.
I have tried many, many variations but none work correctly. I am afraid
that I am thinking about this all wrong so I am intentionally omiting the
querys I have tried so far. If requsted I can provide this.
How would one of you attempt this?
Thank you,
Jeffrey K. Ries