I have to tables, category and item, Each item belongs to a category. I have 5 apps,
- category_grid => grid_application, list of all categories, I have field link to category_form
- category_form => single-row form application, has master-detail to item, I named it category_item_form
- category_item_form => editable gridview form application
- item_grid => grid application, list of all items has field link to item_form
- item_form => single-row form application
The problem is in category_item_form. It used to be working ok, but now when I add new record or update record, it always redirect to item_form. How to stop this?
FYI, I put the category_item_form in separate block than the category fields, since this is master-detail. Now, the program looks ugly since after every changes or add new record the item_form is displayed and I need to click on “EXIT” to get the editable gridview category_item_form. I cannot see any setting or code in event to redirect to form applicaiton after update/insert.
The rationale between multiple way to manage items is that mostly I will add item through item_grid app then click on “Add New” or seach for the record to be updated and then update it. However, I sometimes also need to update the price of the items. It will be much easier to update from the category_item view since all items in one category is there, thus reducing forgotten item to be updated. I understand that through item_grid I can also filter per category and update in here, but item_grid is grid application, I cannot quickly make update, need to click and update one by one. Other solution is to change item_grid to be editable gridview form application instead of grid application. But this also rise another issue since I need item_form page to display more information, not just item fields. editable gridview form application does not have Field Link so that I can go to item_form.