ekendricks
Posts: 34
|
| Posted: 06/02/2005, 3:27 PM |
|
Using MS Access 2000 - Asp - CCS 2.2.3.24
I have an Add/Edit grid "Procedures" with a textbox for "Code". The code is taken from the "Code Table". I changed the textbox to list box, and set DataSource=Code Table, BoundColumn=CodeID, Text Column=CodeName, and Date Type=Integer. The "Code Table" has in excess of 13K records.
When I load the "Procedures" page, it times out. I deleted all but a few records from the "Code Table" and the page loads perfectly. Is my problem the amount of records in the "Code Table", (as it appears to be) in that table. If so, is there a work around?
My major concern is that I have several other such functions in the website, and now I'm concerned about the number of records 6-12-24 months from now.
Thanks
Ernest
|
 |
 |
ryan
Posts: 41
|
| Posted: 06/02/2005, 11:06 PM |
|
listbox is good for 100 records or less but for 13K records you need a popup window then click the item for that textbox to load on the parent window CCS already did this as smart lookup
POP up list & Smart Lookup
http://examples.codecharge.com/ExamplePack/PopUpList/PopUpList.php
_________________
(\__/)
(='.'=)
(")_(") |
|
|
|
|
