How to change values in parent tables in a DbCJGrid

[Vincent Oorsprong]

Bengt,

Normally you would not allow changing column values in a parent row when creating or editing rows that point to the parent row as it would change the value for all other rows pointing to the same parent row. Because of this you'll find the following line in your parent DD class

Set Foreign_Field_Option DD_DEFAULT DD_DISPLAYONLY to False

Knowing this makes that when you want to overrule the situation you could change the setting in your parent DDO. To illustrate I used the order.vw (from order entry). The code there is:

    Object oVendorDataDictionary is a cVendorDataDictionary
    End_Object

    Object oInventoryDataDictionary is a cInventoryDataDictionary
        Set DDO_Server to oVendorDataDictionary
    End_Object

    Object oCustomerDataDictionary is a cCustomerDataDictionary
        Set Field_RememberedValue Field Customer.Customer_Number to 18
    End_Object

    Object oSalesPersonDataDictionary is a cSalesPersonDataDictionary
    End_Object

    Object oOrderHeaderDataDictionary is a cOrderHeaderDataDictionary
        Set DDO_Server to oCustomerDataDictionary
        Set DDO_Server to oSalesPersonDataDictionary       

        // this lets you save a new OrderHeader from within OrderDetail.
        Set Allow_Foreign_New_Save_State to True
    End_Object

    Object oOrderDetailDataDictionary is a cOrderDetailDataDictionary
        Set DDO_Server to oOrderHeaderDataDictionary
        Set DDO_Server to oInventoryDataDictionary
        Set Constrain_File to OrderHeader.File_Number
    End_Object

    Set Main_DD to oOrderHeaderDataDictionary
    Set Server to oOrderHeaderDataDictionary

and you can change this to:

    Object oVendorDataDictionary is a cVendorDataDictionary
    End_Object

    Object oInventoryDataDictionary is a cInventoryDataDictionary
        Set DDO_Server to oVendorDataDictionary
        
        Set Foreign_Field_Option DD_DEFAULT DD_DISPLAYONLY to False
        Set Foreign_Field_Option Field Inventory.Description DD_DISPLAYONLY to True
    End_Object

    Object oCustomerDataDictionary is a cCustomerDataDictionary
        Set Field_RememberedValue Field Customer.Customer_Number to 18
    End_Object

    Object oSalesPersonDataDictionary is a cSalesPersonDataDictionary
    End_Object

    Object oOrderHeaderDataDictionary is a cOrderHeaderDataDictionary
        Set DDO_Server to oCustomerDataDictionary
        Set DDO_Server to oSalesPersonDataDictionary       

        // this lets you save a new OrderHeader from within OrderDetail.
        Set Allow_Foreign_New_Save_State to True
    End_Object

    Object oOrderDetailDataDictionary is a cOrderDetailDataDictionary
        Set DDO_Server to oOrderHeaderDataDictionary
        Set DDO_Server to oInventoryDataDictionary
        Set Constrain_File to OrderHeader.File_Number
    End_Object

    Set Main_DD to oOrderHeaderDataDictionary
    Set Server to oOrderHeaderDataDictionary

This change allows changing the unit price but not the description.