>I have a table with a relation with 3 tables on the same field
>
>table0
> typevalue
> value
>
>table1
> typevalue1
> value
> ds_value
>
>table2
> typevalue2
> value
> ds_value
>
>table3
>...
>
>I have a grid on table0 and i need to change the grid1.column2.controlsource when table0.value changes, because
>when table0.typevalue=1 i want the table1.ds_value and when table0.typevalue=2 i want the table2.ds_value.
>I can´t create a table with the values of table1, table2 and table3.
>Wath i have to do for this to work.
>
>Thank´s for reading this problem
You better use some custom Form.method to make all manipulations:
ColumnX.Controlsource=Thisform.GetcolumnX()
***Form.GetColumnX method
DO CASE
CASE Table1.FieldX=...
Return table2.FieldY
....
CASE Table2.FieldX=...
Return table3.FieldY
ENDCASE
Edward Pikman
Independent Consultant