How can I use two Media fields in a dynamic way to use on a Brick?

joostheger

I have a record A with a Media field: "Specific Image". Then I also have a Media-flowfield, refering to some master data: "Master Image". Whenever I display this record A as a tile, I want to use Master Image to be used on my Brick, unless I have uploaded a Specific Image. Then I want to show that.

joostheger

Got it already!

field("Top Edge Image"; TopEdge.GetHasSpecificImage() ? TopEdge."Specific Image" : TopEdge."Edge Image")

  trigger OnAfterGetCurrRecord()    begin
      TopEdge.CalcFields("Edge Image");

joostheger

table 50011 "A"
{
DataClassification = CustomerContent;

fields

{

    field(10; "Code"; Code[20])

    {

        Caption = 'Edge Code';

        TableRelation = "Master Table"."Code";

        ValidateTableRelation = false;

    }


    field(70; "Master Image"; Media)

    {

        Caption = 'Master Image';

        ToolTip = 'The schematics of the edge';

        FieldClass = FlowField;

        CalcFormula = lookup("Master Table".Image where("Code" = field("Code")));

    }

    field(75; "Specific Image"; Media)

    {

        Caption = 'Specific Image';

    }

    field(80; "Brick Image"; Media)

    {
//Show "Specific Image" is there is one, otherwise fall back to "Master Image"


    }


}

fieldgroups

{

    fieldgroup(Brick; "Code", "Brick Image")

    {


    }



}

joostheger

Got it already!

field("Top Edge Image"; TopEdge.GetHasSpecificImage() ? TopEdge."Specific Image" : TopEdge."Edge Image")

  trigger OnAfterGetCurrRecord()    begin
      TopEdge.CalcFields("Edge Image");