3/10/2024 0 Comments Scriptcase see more of a field![]() The grid application must have a row based button implemented to select the related record and call the original form application with both the ID of the original master record as well as the ID of the record in the related table that was selected in the grid application. I am thinking that perhaps one might have a user defined button in the master form application that can call the grid application with the ID of the master record being edited as a parameter (i.e. However, In my use case, I would have thousands of existing categories and would need a grid/search application to find the right one. There is no search facility beyond the alphabetically listed category name in the drop down field of the master form (product table). ![]() The Editing-select-field gives a possibility of editing or adding a record in the related table (category in the example) from the master form (products). Unfortunately, I do not see how they can solve the problem. One would need a separate, lookup, grid application in it’s own right with search facilities on several fields of the dept_role table.Ĭreating a grid application for department role is easy in scriptcase, but how can one link the grid application to the master form, so that it is bound in modal mode to the pt_role_id field in the master form, for example by having a button that opens the grid application for department role in modal form and returns the selected dept_role_id to the pt_role_id field in the master form. In this case just defining the pt_role_id as a select field where the select drop down field in the master employee form displays the names of the department roles (i.e. For my example, let’s assume that there were thousands of department roles, they were organised hierarchically and there were additional fields needed to be searched on in order to find the right department role for an employee – a rather contrived example, but it illustrates my problem well. However, what if department roles were not that simple. dept_role.name), it can then be used as a dropdown select in the employee master table for the pt_role_id field. If you have a simple text field with the name of the department role (e.g. In Tim’s example you have a lookup in dept_role table to find the id of the dept_role record to be used in the master table (for example named employee). However, it is something more advanced that I am looking for. I know that you can relate from one field in a master table to a lookup table as described by Tim. What is needed is that the lookup grid application is run in modal mode and that a specific key or node-id can be returned and inserted in the relevant field in the master table.Īny ideas on how one could implement this is appreciated. One can create nested grids, but they are not bound to specific fields in the master table (AFAIK) and they are shown either below the original master table or in an extra, own field. Rather, a full grid application with search features would be in order. In such cases a simple drop down selection list is not really adequate. ![]() However, sometimes a more advanced lookup may be needed, for example a node_id from a related table that may contain hierarchical structure with several fields in it’s own right. ![]() an integer ID) from the related table to the field from the first master table that needs validation. This gives a simple selection list of a text field values from a related table, but inserts the key (e.g. ScriptCase has already implemented a ready made lookup function on fields defined as type “select”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |