Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two Controlsources for one Grid Column
Message
From
23/07/1998 11:25:57
 
 
To
23/07/1998 11:22:28
Joao Godinho
Fredesenvolv, Lda
Lisbon, Portugal
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00120490
Message ID:
00120492
Views:
15
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform