I need some help with adding/editing records in a table that contains a column related to another table.
I have a series of tables which will contain about 5,000-10,000 rows. The tables contain the tasks that people have worked on or calls made, etc. New rows added to a table have to contain a valid ID for a person. Of course it isn't reasonable to ask the data entry person to know every ID, so they will enter a Last Name and then I want the system to offer them a choice of people and on selection, record the ID number of the person chosen in the grid.
Rows might also be updated to change the person chosen.
The trouble is that the list of people who might possibly be used will grow very long over time, possibly drawn from as many as 10,000 people or more. For this reason, I don't want to use a drop down box. I want to use a plain text field to enter the last name and have the user prompted in some way to select the correct person (by first name or company).
In a Windows Forms app, I would use a simple pop-up window to present the choices and when the pop-up was closed, check that a selection had been made and if so, record the ID in the appropriate column.
I understand that pop-ups can be problematic in Web Forms, but is it possible using the Telerik Grid (AJAX preferably) to do something that would achieve the same effect if a pop-up won't be possible?
Thanks,
Simon
2 Answers, 1 is accepted
0
Hi Simon,
The RadGrid control displays the values of a data source in a table where each column represents a field and each item represents a record. The RadGrid control enables you to select, sort, filter, edit and add new items. For your case you can use filtering and paging capabilities of the RadGrid. You can customize and extend the code from the examples according to your needs.
Greetings,
Plamen
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
The RadGrid control displays the values of a data source in a table where each column represents a field and each item represents a record. The RadGrid control enables you to select, sort, filter, edit and add new items. For your case you can use filtering and paging capabilities of the RadGrid. You can customize and extend the code from the examples according to your needs.
Greetings,
Plamen
the Telerik team
Instantly find answers to your questions at the new Telerik Support Center
0
Simon
Top achievements
Rank 1
Rank 1
answered on 02 Jul 2008, 11:29 AM
Thank you Plamen.
I scanned the links you sent but they are for single table filtering and paging, not my need to look up, select and insert records based a related table.
I've moved on from that idea and have decided to handle to addition and editing of records using pages designed for the purpose and to use RadGrid as just a display mechanism.
- Simon
I scanned the links you sent but they are for single table filtering and paging, not my need to look up, select and insert records based a related table.
I've moved on from that idea and have decided to handle to addition and editing of records using pages designed for the purpose and to use RadGrid as just a display mechanism.
- Simon