Conditional lookup on value of parent table

PHPMaker General Discussion (PHPMaker)
1

Hi,

I have the following two tables setting and theme.

Table 'Setting':

setting_key 
setting_value

Table 'Theme':

name
calc_bg

I want to create a lookup like this:

if (setting.setting_key == ‘active_theme‘ then theme.name)
if (setting.setting_key == ‘calculator_step‘ then theme.calc_value)

Any Idea

mpol_ch

2

Your description is not very clear (I assume calc_bg is same as calc_value), you may want to explain more.

3

Hi,
I want toe filte the lookup table with help of parent table “setting_value”.

IF setting.setting_value == active_theme THEN “select name from Theme”..
IF setting.setting_value == ‘calculator_step” THEN “select calc_bg from Theme”..
IF setting.setting_value == ‘kon_text” THEN “select calc_bg from TableText”….

etc.

The lookup table will that be shown as radio_button and will depended on parant table’s columns.

mpol_ch

5

No, the Lookup Table for a lookup field is fixed, you cannot dynamically change from "Theme" to "TableText".

However, it is possible to change from select name from Theme to select calc_bg from Theme (if Theme is the lookup table) by Lookup_Selecting server event. You can change the UserSelect property according to the FilterValues property.