Hi All,
I've got three oracle tables:
TRAIN_STATIONS
Fields: ABBRV, NAME
Description: contains train station records
STATION_GROUPS
Fields: ID, NAME
Description: contains group name records.
STATION_GROUPS_J
Fields: GROUP_ID, ABBRV
Description: a table containing the train station records associated with each station group. If there is a group1 with a group_id of 1, then you might have 4 train station records in the table associated with the group_id of 1.
Hopefully, we are all on the same page. I have one asp page built with a table at the top that displays the group names. Halfway down that same page, I have two folder tabs, one for the group info and the second for the stations. These are separated on the page using the <div> html tag. The Group Info tab contains a text box that you can use to add, update or delete group names from the groups table.
The second tab, Stations, contains a table like the group table at the top of the page, populated with all of the records from the train_stations table. This might include a select all and unselect all command buttons. Each record has a checkbox beside it and what I would like to do is be able to have those check boxes turned on next to the records that are included in the group selected from the group table above. I would like to add stations or remove stations from a selected group or create a brand new set of selected stations for a new group.
Any help on this problem would be greatly appreciated,
Todd
I've got three oracle tables:
TRAIN_STATIONS
Fields: ABBRV, NAME
Description: contains train station records
STATION_GROUPS
Fields: ID, NAME
Description: contains group name records.
STATION_GROUPS_J
Fields: GROUP_ID, ABBRV
Description: a table containing the train station records associated with each station group. If there is a group1 with a group_id of 1, then you might have 4 train station records in the table associated with the group_id of 1.
Hopefully, we are all on the same page. I have one asp page built with a table at the top that displays the group names. Halfway down that same page, I have two folder tabs, one for the group info and the second for the stations. These are separated on the page using the <div> html tag. The Group Info tab contains a text box that you can use to add, update or delete group names from the groups table.
The second tab, Stations, contains a table like the group table at the top of the page, populated with all of the records from the train_stations table. This might include a select all and unselect all command buttons. Each record has a checkbox beside it and what I would like to do is be able to have those check boxes turned on next to the records that are included in the group selected from the group table above. I would like to add stations or remove stations from a selected group or create a brand new set of selected stations for a new group.
Any help on this problem would be greatly appreciated,
Todd