Very general question on form vs grid

Scriptcase 9 General
#1

I’ve been doing SQL since the 1980s and used a variety of front ends. I am a little perplexed on the Form vs Grid here. Just a simple table attached to a single form. The form begins with ADD NEW. That works fine. But after the insert it sits there with the ADD button and nothing displayed. There seems to be no way to search, the button is not back to “add new” it just sit on ADD. I imagine the idea is to fill out the form and you can repetitively keep adding. But you can’t update from this form now because there is nothing displayed and no way to search.

Grids seem to search, but aren’t ideal for adding. I am not quite figuring out the logic flow in how this should work. Is there anything useful to help?

#2

Grid and form works together

You use the grid to do search and display the matching result

You then use the Form to add new data, do update or delete it, you have option to navigate in the Form if needed

#3

Thank you. Does an editable grid remove the need for a form?

#4

Yes it does, but if you have a big form, need Master/Detail support, special functionality, etc., you need a form.

Most of the time I use Form for the main data and editable grid for configuration data

#5

If you check Form Settings > Toolbar, it seems like you have only “Insert” showing. If you add “Update”, “Delete”, you should be able to do other aspects of CRUD with any type of form.

Hope I got the issue right.