I have been searching this site and haven't been able to see if this is possible yet.
I would like to take a search query from my STATUS db, output it into an html page with checkboxes next to the displayed information so my boss can review and select the information he wants to present. When the checkbox is selected next to the desired data, I would be able to save this information into another db called STATUS_OUTPUT (or something like that) so I can perform a general display query of that information to display in a Project update html page.
I currently have these fields defined in STATUS db:
ID => [0, 'numer', 5, 8, 1, '', ''],
Date => [1, 'date', -1, 15, 1, &get_date, ''],
Manager => [2, 'alpha', 25, 35, 0, '', ''],
Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
Next_1 => [9, 'alpha', '50x1', 50, 0, '', ''],
Next_2 => [10,'alpha', '50x1', 50, 0, '', ''],
Next_3 => [11,'alpha', '50x1', 50, 0, '', ''],
When a query is performed, I would like to see the information from the multiple records presented in this order with checkboxes next to the approriate info on an html page:
CHECKBOX Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
and so on. When the checkbox is selected next to the desired information, a save button can be clicked and the records information associated with the selected fields can be saved into another database.
The goal ist o have users submit their information, the manager to review and select the highlights he would like to present, have this saved into another database then have this new db information queried and placed within another html page.
Can this be done? If so, any pointers to where I might find informationon how to do this?
Any and all help will be greatly appreciated.
John
I would like to take a search query from my STATUS db, output it into an html page with checkboxes next to the displayed information so my boss can review and select the information he wants to present. When the checkbox is selected next to the desired data, I would be able to save this information into another db called STATUS_OUTPUT (or something like that) so I can perform a general display query of that information to display in a Project update html page.
I currently have these fields defined in STATUS db:
ID => [0, 'numer', 5, 8, 1, '', ''],
Date => [1, 'date', -1, 15, 1, &get_date, ''],
Manager => [2, 'alpha', 25, 35, 0, '', ''],
Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
Next_1 => [9, 'alpha', '50x1', 50, 0, '', ''],
Next_2 => [10,'alpha', '50x1', 50, 0, '', ''],
Next_3 => [11,'alpha', '50x1', 50, 0, '', ''],
When a query is performed, I would like to see the information from the multiple records presented in this order with checkboxes next to the approriate info on an html page:
CHECKBOX Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_1 => [3, 'alpha', '50x1', 50, 0, '', ''],
Detail_1 => [4, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_2 => [5, 'alpha', '50x1', 50, 0, '', ''],
Detail_2 => [6, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
CHECKBOX Highlight_3 => [7, 'alpha', '50x1', 50, 0, '', ''],
Detail_3 => [8, 'alpha','100x5', 500, 0, '', ''],
and so on. When the checkbox is selected next to the desired information, a save button can be clicked and the records information associated with the selected fields can be saved into another database.
The goal ist o have users submit their information, the manager to review and select the highlights he would like to present, have this saved into another database then have this new db information queried and placed within another html page.
Can this be done? If so, any pointers to where I might find informationon how to do this?
Any and all help will be greatly appreciated.
John