Relations between user defined tables...

[Former Member]

Hi,

I'm trying to add several user defined fields to the Item Master Data which have relations between each other.

Is it possible to build a kind of cascade where depending on the selection of one field, the options for selection of the following field will change accordingly?

Ex:

Table/Field Type:

Type A (refers to color RED)

Type B (refers to color BLUE)

Type C (refers to color RED and BLUE)

Table/Field Color:

If selected above C the options will be RED and BLUE;

If selected above A the option will be RED;

etc...

Tkx,

Vítor.

[Former Member · Accepted solution]

How many combobox do you want to populate? This can be quite slow if you have lots of data

Cheers,

Cyril

[Former Member · Accepted solution]

Attach formatted searches to those two comboboxes... If combobox 1 changes, update combobox 2... SBO handles this, so it's quite fast...

[Former Member · Accepted solution]

how do we update combobox 2, after selecting the combo 1 ?

[Former Member · Accepted solution]

Well, instead of the comboboxes I decided to use simple User Defined Fields with formatted searches attached, searching the User Defined Tables.

I tried to do the formatted searches but I couldn't execute the second one!

Maybe the query is wrong but I don't get any error either!

Maybe an example for the second combo would help me!

PS: I think the problem might be the fact that I can't find a way to identify the field of combobox1 to use on the query!

Regards,

Vítor.

[Former Member · Accepted solution]

Hey Vítor,

If it does not give any error, the query looks good, but doe snot return any results (so it's not good after all) It could have something to do with the lookup to the first comobox.

In your query you should refer to the first combobox like

$[$COMBO_ONE.0.0]

(where COMBO_ONE must be replaced with the Unique ID of your first combobox)

Note, in the query, do <i>not place quotes around it, SBO handles this for you...

Good:

SELECT var FROM tbl WHERE other_var = $[$COMBO_ONE.0.0]

Wrong:

SELECT var FROM tbl WHERE other_var =

'

$[$COMBO_ONE.0.0]

'

Hope it helps...

Grtz, Rowdy

[rasmuswulff_jensen]

gues you talk about two comboboxes..

Catch combobox 1 selected value and popolate combobox 2 with new valid values... Don't think that there are a more fancy way...