ekendricks
Posts: 34
|
| Posted: 06/17/2006, 10:47 AM |
|
Using CCS - SQL 2005 - ASP
I have a table with approx 1000 employees. Employees are assigned to a Post ("PostID"). I have a dropbox "Employee" on an entry form, where the contents of the dropbox is filtered by session.variable ("PostID") ie: PostID = 20, and returns a few employees (which is correct) instead of listing 1000 employees. On the same page, I have a function, that pops up a page, where I can find and select an employee that is not in the original list, (PostID = 35), click on that employee, and he is added to the dropbox list. The save operation saves that employee into the database.
All of the above works great as intended. My problem comes in when I need to edit that record. When the form is opened in the edit mode, the employee that was selected, (PostID=35), and recorded earlier, is now being filtered out by the session variable ("PostID"), (PostID=17). My question is: How can I maintain that filter in Edit Mode, and also show the employee previously selected.
Thanks
Ernest
|
 |
 |
|
