very newbie question

Scriptcase 9 General
#1

I am trying to link from a customer grid to a customer address grid, and only want to the addresses associated with that customer. Can someone provide the basic steps as nothing I have tried has worked. I will need to pass the customer id to the address grid and only pull those associated with that id.

When I try to add an application link to the grid, it only shows forms :frowning:

#2

Have you tried nested grid?

  • First you must have your customer grid
  • Then , you must create another grid, related to the adress. In the sql query, you must add MANUALLY a where condition, to filter the addess of a particular customer. For example: where cust_id=[cust_PK]
  • Please note the bracket variable. Scriptcase will later convert it to a link between the 2 grids
  • Save and compile
  • In the first (customer) grid, add a nested grid:
    – Select the new adress grid
    – It will show the address grid spected variables. in this case, it will show cust_PK. You must select the local field, and link it to cust_pk.
  • Save and compile.
  • The customer grid must have now an “expand” plus sign, wich only shows the filtered adderss.

Hope it helps

#3

Jomscl is right. When using two grid applications in Scriptcase you will need to do a nested grid. Application links are for navigating from grid to form and vice versa. Field links work the same way. Another option, if you don’t want all of that information loading together every time you go to the grid, you can always create a single form with the customer information and use master detail to show a grid view or editable grid view listing on the same page as the main record. Both grid view and editable grid view are forms as well but have the grid format. Either way, the example process mentioned above of adding the WHERE clause to the SQL of the address grid is how you link them to show only the records you want. One last idea, if you wanted to use the application link, you would need to re-create the address grid as a form and choose either grid view or editable grid view. This change will let you do what you were originally trying to do. Just be sure to use the where clause in your sql of the address program. Hope this helps!