This is a rather vague question. I have a classic join table situation. I put a key from table A and a key from Table B in a join table. The join table record either exists or it doesn't exist. If it does exist another process selects the records from table A and B. (This is a one to many situation.)
My concern is this. I already have a working solution for this. I have a popup in the screen for editing table A that creates/deletes join table records for a particular Table A record.
The popup screen consists of a RadGrid with table B records and a checkbox for each record. The grid loads from a view that loads all table B records and whether or not a join exists for them with Table A (to set the check boxes.) Once displayed the users can check or uncheck boxes as they please. When the Save button is hit, the codebehind adds/deletes join table records as needed.
This works fine so far but I'm just wondering that if table B grows to some hundreds of records, this might become cumbersome. I believe it would be simple to 'Ajaxify' the situation so that adds/deletes take place the instant the box is clicked but on the other hand I wonder if I need to maintain a user interface in which changes only take place as a whole.
Suggestions?
My concern is this. I already have a working solution for this. I have a popup in the screen for editing table A that creates/deletes join table records for a particular Table A record.
The popup screen consists of a RadGrid with table B records and a checkbox for each record. The grid loads from a view that loads all table B records and whether or not a join exists for them with Table A (to set the check boxes.) Once displayed the users can check or uncheck boxes as they please. When the Save button is hit, the codebehind adds/deletes join table records as needed.
This works fine so far but I'm just wondering that if table B grows to some hundreds of records, this might become cumbersome. I believe it would be simple to 'Ajaxify' the situation so that adds/deletes take place the instant the box is clicked but on the other hand I wonder if I need to maintain a user interface in which changes only take place as a whole.
Suggestions?