List Values in a Combobox

[ZEP]

HI,

I have several tables

tableA (id_product,id_type_prod,name)

tableB (id_product, name)
1 - ProdA
2 - ProdB
3 - ProdC

tableC (id_type, name)
1 - Daily
2 - Weekly
3 - Monthly

tableD (id_type_prod, id_product, id_type)
1 - 1 - 1 (ProdA - Daily)
2 - 1 - 2 (ProdA - Weekly)
3 - 2 - 1 (ProdB - Daily)
4 - 3 - 1 (ProdC - Daily)
5 - 3 - 2 (ProdC - Weekly)
6 - 3 - 3 (ProdC - Monthly)

The form is for tableA, where I want to show in comboxA the values of
tableB, and in comboxBoxB only the values of a tableD (with the name of
tableC) where the id_product is the of tableA. The form is to be shown in
Datasheet or Continuos Form.

How can I do this.

Thanks in advance,
ZEP

 

[Hung.cao]

If i'm understand your problem correctly. Here is how you do it.

In your continous form there is 4 fields combox goes across

ComboxA -> source code = a query name which list all the value on
table A. On the onclick property you may want to call the do requery
for comboxB base on the value you choose on comboxA. Repeat this step
for C and D.

Use query for each combox box .... the citeria for each query ..
form![mainform]!namecombobox.

Hope it helps.

 

[Hung.cao]

If i'm understand your problem correctly. Here is how you do it.

In your continous form there is 4 fields combox goes across

ComboxA -> source code = a query name which list all the value on
table A. On the onclick property you may want to call the do requery
for comboxB base on the value you choose on comboxA. Repeat this step
for C and D.

Use query for each combox box .... the citeria for each query ..
form![mainform]!namecombobox.

Hope it helps.