5 Replies Latest reply on Nov 8, 2016 8:26 AM by kohlstech

    Data from one field to another field in a another table.

    kohlstech

      My First Table fields      DELIVERY 2016            

       

      DC = (number)

      Store = (Number)

      Delivery Date = (Date)

      Trailer Number = (Text)

       

      My Second Table           DELIVERY DATA

      Store = (Number)  Relationship to the First Table

       

      Store6/86/96/10
      1
      2
      3
      4
      5
      6
      7

       

      what i am trying to do is the fields on table 2 6/8 6/9 6/10

      in a calculation

       

      match the store number in table 1 and show the trailer number that matches the Delivery date.

       

      This is what i tried it the 6/8 Field

       

      Case( DELIVERY 2016::Delivery Date = Date ( 6 ; 8 ; 2016 ); DELIVERY 2016::Trailer Number;"")