6 Replies Latest reply: Dec 2, 2011 5:50 PM by Aissam Boumejjane RSS

    one field from 2 tables

    Aissam Boumejjane

      Hi Guys,

       

      I have 2 tables:

       

      TransitTimes:      //table 1

      ID,

      TransitTime

       

       

      Data:                   //table2

      DateReceived,

      DateArrived

      if(networkdays(DateReceived,DateArrived)<=TransitTime, 'OnTime', 'Late') as Status // this offcourse won't work, since the field "TransitTime" does not exits in the table 'Data'.

       

      How could I create the field 'Status' from the 2 tables above?

       

      Thanks in advance!

       

      Cheers,

       

      iSam