General information
Category:
The Mere Mortals Framework
Kevin, Here are the answers to your two questions. I hope I am giving you all the info you wanted.
1) How exactly do you have this relationship set up?
The relationship is set up as follows:
In Page2 of the form, there are two views involved:
lv_AllFlds (from the imc_AllF table) for the lstFullList list of KMoverObj
lv_SelFlds (from the imd_SelF table) for the lstSelected list of KMoverObj
In the lv_SelFlds view, the Join is:
Inner Join => imc_AllF.iId = imd_SelF.iFldId
2) How does the KMoverObj Selected view populate the cGrid view?
The form has three pages. In the UIEnable() Method of Page3, I have the following code:
LPARAMETERS lEnable
DoDefault()
If lEnable
This.LoadCursor()
Requery( 'v_SelWidth' )
Go Top In v_SelWidth
Else
TableUpdate( 1, .T., 'v_SelWidth' )
EndIf
the LoadCursor() Method on Page3, updates the lv_SelWidth view also on Page3 from
the lstSelected array on Page2 & from the lv_SelFlds view also on Page2 as follows:
1) If the aSelList array of Page2 is empty, then empty the v_SelFlds view & return
2) Disable the "Automatic Update" by copying the "Selected List" array to the
"Backup Selected List" array.
3) Delete records in v_SelFlds for records deleted from the array
4) Perform a manual update by copying the lv_SelFlds view to the lv_SelWidth view
but keeping intact all fields already in the lv_SelWidth view.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only