dynamic link look up from ano ther table

Applications Forms
#1

When add the from i have example car

trademark + model + submodel

when user select trademark then (such as BMW) then the it list only model 9 that belong to BMW) then user can select submodel (depend
on model that he select)

Please suggest

#2

Re: dynamic link look up from ano ther table

Do you mean something like:
http://www.scriptcase.net/sistemas4/exemplos_en_us/grid40/grid40.php

There are several other examples as well if you poke around for a while.

Regards,
Scott.

#3

Re: dynamic link look up from ano ther table

Hi,

I am trying to create a system which needs the field value to be
filled by selection.
In our example.

  1. Reference field should be filled by selection
  2. When WF Code is selected, the AJAX event should change the Select (button) to Link into the form available in below table WFM_RefPiclupForm.
  3. Once the Data is selected the form (dynamically) then the value should get filled in Reference text

On this ,

  1. can i Create dynamic buttons which have links to the exiting Forms
  2. Or can It be possible Link forms dynamically on Ajax events for to Pickup values from different availble fomr(s)
  3. Or Can it be possible to have Lookup Dynamically Keep changing through code…? (refer Sc2.jpg)

Regards
Dhana

#4

Re: dynamic link look up from ano ther table

(Posted in the Forum because for others to refer similar kind of issues and get solutions)

Reply by Vinicus
Subject: RE: Reg. Pickup value Dynmically
Date: 2009-12-08 Time: 23:23:51
Hi Mr. Dhanaraj,

You can create the button and use sc_btn_display to off/on this button.

The values in field can access by {name_of_field} , and you can redirect to other application with the macro sc_redir().

Don’t is possible, alter this lookup dinamically, only you use a variable global [variableX] in this field and attribute value to it’s.

Regards,

Vin?cius Muniz
Netmake Solu??es em Inform?tica
Conhe?a as novidades do Scriptcase V5:
http://www.netmake.com.br/forum/index.php?topic=1336.0

#5

Re: dynamic link look up from ano ther table

Hi Vinicius,

Ya, When I create a Button it sits on top or bottom of the application. I couldn’table to include in the Block…?

My second query is, There are some samples on by using PICKUP Forms in samples.
There the Pickup form is linked statically. Is it possible to dynamically change the Link of the Pickup table…?

Regards
Dhana

#6

Re: dynamic link look up from ano ther table

Ya, When I create a Button it sits on top or bottom of the application. I couldn’table to include in the Block…?

As far as I know you can’t. However you can make a field clickable with a javascript onclick event. Use CSS properties to make the field look like a button. Dirty, but it works.

There the Pickup form is linked statically. Is it possible to dynamically change the Link of the Pickup table…?

Again, as far as I know not possible. However, workaround could be to create a custom link and pass a parameter/global to the application to be called. Use this parameter to create your query dynamically. Hope it helps.