utrost
Posts: 9
|
| Posted: 08/30/2005, 7:22 AM |
|
Heya,
I have 2 quite large tables
- Products (approx. 3 million entires)
- Manufacturer (aprox 200.000 entiries)
Now I need to create a website to enable a user to assign a manufacturer to a product, knowing the name of both.
With smaller tables two listboxes would be the obvious choice.
Just having two textboxes where the user could type in the names of the product and the manufacturer would be another possibility.
However the user could misstype the names which eventually leads into blank chaos, esp. because both names are case-sensitive.
A alphabetical directory for both would be ideal - but i dont know if/how this is possible
I am sure that I am not the first one with these kind of problem. Are there any ideas outhere?
Uwe.
|
 |
 |
E43509
Posts: 283
|
| Posted: 08/30/2005, 9:51 AM |
|
I had a similar problem with 30K entries. I used 'smart lookup' technique where you open another small form that can filter the data. Excellent example found http://examples.codecharge.com/
|
|
|
|
E43509
Posts: 283
|
| Posted: 08/30/2005, 9:52 AM |
|
PS I also validate the entry after submit to ensure it is still correct and they didn't accidentally type over a character
|
|
|
|
utrost
Posts: 9
|
| Posted: 08/30/2005, 10:00 AM |
|
Thanks E43509,
at a first glance i would say thats exactly what I need!
|
|
|
|
|
