DeSaedeleer
Posts: 8
|
| Posted: 11/16/2006, 5:47 AM |
|
I have to build an application where relations are set between "Projects" and "Employees". The examples "Updating Many-to-Many Relations via Checkbox Lists or Multiselect listbox" are nice but not suitable for my application. The selections are based on Listboxes. This is nice if there are not a lot of emplyees and projects. In my Department, there are 3000 employees and lots of projects. So I'd like to replace the listbox lookup by a search form, presenting the results (e.g. the found employees) in a grid. Clicking on an Employee Id and later on a Project Id passes these Ids to an update screen where a (custom) insert can be performed. But how to pass and later use these parameters ?
All suggestions are welcome
Kind regards
|
 |
 |
Edd
Posts: 547
|
| Posted: 11/16/2006, 1:43 PM |
|
Depending upon your expertise, there are many solutions.
The easiest solution for your case is to use a couple of Popup windows where the search and selections are performed in the popups and passed back to the calling window via Javascript.
If you google your "Javscript :popup passing parameters" or such you will a ton of examples.
When your expertise grows you move into Ajax and all of this becomes a new ball game, e.g. I use a ajax combo to search through 65,000 names.
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
|
