I have a desktop application built against dbf tables. I would like to create a WEB module for the application. The web side will use 4 grids. 2 Grids will use 2 tables for lookup information and the 3rd will be populated by values from the lookup grids along with data entered by the logged in user. The 4th grid is used to show the results. All grids will be displayed on a single WEB page.
I have managed to create a log in and set session variables during the log in process. Using the session variables, I open the first grid filtered properly. When selecting the desired row in the first grid, I then open the second grid filtered on values from the first grid.
I then want to open a 3rd grid as a enter only form to enter a new record using values from the 1st and 2nd grid, including values from hidden columns, along with additional data entered by the user.
On the desktop side, I could use xbasic to do this. I don't have a clue how to do this on the WEB side. I don't know if I need to create arguments, session variables, client side or server side events, use java script, Ajax or what. I've been looking at some of the videos. While helpful in that I'm learning more about developing on the WEB side, I haven been able to learn how to do what I need.
I've attached three pictures. The first is the desktop form. The second picture is where I am with the WEB page development.
The first grid is filtered by the logged in user and available work orders. Selecting the desired work order opens another grid with the available discrepancy items for that work order. The item number on-click event opens the third grid, a form view enter only grid. I want the grid to display non-editable information from the first 2 grids to help the user verify his entry will be against the desired item number. Only the Date, hours and work done are to be entered by the user. However; when the Submit button is pressed, values from hidden fields will need to be written to that same table.
NOTE: Although Item No shows a 1, that has been hard coded as a default temporarily.
The last picture shows the fields in the table to which the grid is attached. Most of the hidden fields will need to have values entered when the submit button is pressed.
I need to add a cancel button. I can add the button, but I do not know what code and where to attach to the button.
I have been working with the desktop side for over 20 years. I'm having trouble trying to do the WEB side. Any help will be greatly appreciated.
Ron
I have managed to create a log in and set session variables during the log in process. Using the session variables, I open the first grid filtered properly. When selecting the desired row in the first grid, I then open the second grid filtered on values from the first grid.
I then want to open a 3rd grid as a enter only form to enter a new record using values from the 1st and 2nd grid, including values from hidden columns, along with additional data entered by the user.
On the desktop side, I could use xbasic to do this. I don't have a clue how to do this on the WEB side. I don't know if I need to create arguments, session variables, client side or server side events, use java script, Ajax or what. I've been looking at some of the videos. While helpful in that I'm learning more about developing on the WEB side, I haven been able to learn how to do what I need.
I've attached three pictures. The first is the desktop form. The second picture is where I am with the WEB page development.
The first grid is filtered by the logged in user and available work orders. Selecting the desired work order opens another grid with the available discrepancy items for that work order. The item number on-click event opens the third grid, a form view enter only grid. I want the grid to display non-editable information from the first 2 grids to help the user verify his entry will be against the desired item number. Only the Date, hours and work done are to be entered by the user. However; when the Submit button is pressed, values from hidden fields will need to be written to that same table.
NOTE: Although Item No shows a 1, that has been hard coded as a default temporarily.
The last picture shows the fields in the table to which the grid is attached. Most of the hidden fields will need to have values entered when the submit button is pressed.
I need to add a cancel button. I can add the button, but I do not know what code and where to attach to the button.
I have been working with the desktop side for over 20 years. I'm having trouble trying to do the WEB side. Any help will be greatly appreciated.
Ron
Comment