Populate databasejoin in a Reapet group from other Databasejoin

[jmoises]

Hello i need a little help here, i made a form whit the following fields:

Table1.Field1 (Orden#)
Table1.Field2 (Customer_id) (DatabaseJoin - Autocomplet)

And i made a Repeat Group inside this form :

Table2.Field1_1 ( Product_ID)(DatabaseJoin) Table2.Field1_2 (Product_Desc)

What i need to do, is to be able to filter only the Products from the selected Customer_id, because each customer has is on prefine products.

I try to add WHERE Clause in the Databasejoin but not make it work

thanks for any advise

 

[mamies]

Have you tried using the Cascading Dropdown Element.

This will watch the entry for the first database join and then show a list of options depending on what is chosen.

 

[jmoises]

i now how touse the cascading dropodown element, but i think dont apply because the table2 is a join list in a repeat group i will try to use it but not sure i make it workin on simple forms in the pass,...

 

[jmoises]

lol it work ok with Cascading Dropdown Element.

Thanks