follow grid links

Scriptcase 7 Discussion
#1

Hello
I have tables with customers,addresses, orders. And I want to create links between them.
I create for them separate applications customers,addresses, orders grid and form.

I also want to create ie. on customers link to orders and second to addresses. Is it posiible to create it, based on created ealier grids? Or meybe I must create new grids for this purpose, with defined filter ie on orders and adresses additional where condition to customers. Is it possible to dynamically change where conditions (add where customer_id=…, where it is from othere grid, or without this condition when someone open it from menu)?

#2

Create a field link at customers grid(You could use html image field in this grid) link do address grid and try to use this code on address grid onScriptInit event(check optional on g_address_id global variable ):

if(!empty([g_address_id])){
if (empty({sc_where_atual})){
sc_select_where(add) = “where address_id> [g_address_id]”;
}
else{
sc_select_where(add) = “AND address_id> [g_address_id]”;
}
}

#3

Create a area link at clients grid (You could use web-page coding pictures area in the grid if you would like to create a custom website design)