Here is what I've got:
db table (staff):
-
- fname
- lname
- team
- available (bool)
- on-call (bool)
- etc......
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
webpage for department:
query where team=mydept displays:
| fname | lname | available | on-call | covering |
| John | Doe | Yes | Yes | blank |
| UT | Spam | No | No | jdoe |
| Joe | Blow | Yes | No | blank |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
webpage for admin:
query displays:
| fname | lname | present | sick | vacation | personal | on-call |
covering |
| John | Doe | * | o | o | o |
* | dropdown |
| UT | Spam | o | * | o | o |
o | jdoe |
| Joe | Blow | * | o | o | o |
o | dropdown |
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
I want the admin page to have radio buttons as shown to toggle between:
sick, vacation, personal and present to make the available field on the dept
page.
I want the on-call radio buttons to toggle between the staff listing cause
only one person
is on-call at a time. The drop down should contain all the staff on the team
that != to selected record.
Now, my question is: On the admin page, is there a way to display/control the
listing
as described without making each line a form itself? i.e. I want to click
the appropriate
radio buttons and click one submit button.
Hope that is a clear explanation. Thanks in advance for help or advice.
_________
~UT Spam
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
