G
Guest
I want to give my users a form where they will give some information and a
query will be run based on that. However, I want this to be a bit more
dynamic than just a simply query.
Let me try to explain in more detail.
One of the forms in question will run a query that pulls all training
classes an employee has had. The user would select the employee name and
search by that. However, I also want to give the user several other options
that they either can choose to use or not. For example, I would want to give
them a place to also enter the instructor name. So, they could choose the
employee Peter Venkman and the instructor Bruce Wayne. This would pull up any
course Dr. Venkman took that was taught by Bruce Wayne. On the other hand,
the user could choose the employee Peter Venkman and leave the instructor
name blank, and this would in turn pull up ALL of Dr. Venkman's records no
matter who was the instructor. Is there any way to do this? I think I may
have asked a similar question, but I haven't gotten an answer yet on whether
or not this is possible, and if it is how to do it. Thanks.
--
Have a nice day!
~Paul
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''''''''
ptaylor
query will be run based on that. However, I want this to be a bit more
dynamic than just a simply query.
Let me try to explain in more detail.
One of the forms in question will run a query that pulls all training
classes an employee has had. The user would select the employee name and
search by that. However, I also want to give the user several other options
that they either can choose to use or not. For example, I would want to give
them a place to also enter the instructor name. So, they could choose the
employee Peter Venkman and the instructor Bruce Wayne. This would pull up any
course Dr. Venkman took that was taught by Bruce Wayne. On the other hand,
the user could choose the employee Peter Venkman and leave the instructor
name blank, and this would in turn pull up ALL of Dr. Venkman's records no
matter who was the instructor. Is there any way to do this? I think I may
have asked a similar question, but I haven't gotten an answer yet on whether
or not this is possible, and if it is how to do it. Thanks.
--
Have a nice day!
~Paul
~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''''''''
ptaylor