I am trying to achieve a layout like the image attached. The basics are I have a list of categories. The user selects a category from the list. A list of items in that category are shown. Then if the user selects an item, the details of that item are shown. From what I read, the master-detail is only allowed when a single record view is used. can anyone point me to an example or tell me how to achieve the pictured layout? thanks
If you haven’t yet … create a new project with the SAMPLES demo. Then take a look at these:
Thanks, I forgot I should have included I wanted to users to be able to edit/add records as well.
Thanks for the pointer to the samples.
Use an application link
[QUOTE=leroy_hack;40599]Thanks, I forgot I should have included I wanted to users to be able to edit/add records as well.
Thanks for the pointer to the samples.[/QUOTE]
Turn off the detail view in the grid. Then use an application link to show the form.
Thank you. Being new to scriptcase is an uphill battle until I figure out how it all fits together. Thanks for your help.
Is there a way to customize the link parameter? Or where does it draw it from? In my example the main form has an ID of categoryID the destination form has itemID and categoryID. I want to link the categoryIDs but for some reason itemID is the only field that shows on select values to pass. Parameters = fldItemID value has the fldCategoryID. I think it should be fldCategoryID and value fldCategoryID. (the categoryID is hidden from the user so I can’t use a field link)
I, too, am a newbie. Not sure that I understand what you are saying. To achieve what you show in your illustration; the left pane will be a refined search for the categoryID field of the item table. The top right pane will be a grid of the item table. The bottom right pane will be a form of the item table. (All of these are based on the item table - no the category table) I find it easiest to build the form before the grid.
Step 1. Build the form. You might have an ItemID field (autoincrement maybe), ItemDescription field, and CategoryID field. The CategoryID field will get its value from a lookup; make its data type = ‘select’ then create the lookup to the Category table. Users can either choose a category when adding a new item or you can automate that based on some kind of rule.
Step 2. Build the grid to list the records in the item table … with a LINK to the form that you previously built. The link between the two will be itemID. In the link properties, you want the form to open in an iframe (you can size and position it in link properties as well).
Step 3. Create the refined search by category (on the grid)