2 Replies Latest reply: Jun 27, 2016 11:58 AM by Filip Duchateau RSS

    Linking tables

    Naheem Ali

      I am trying  to create a report using data from two different tables and linking them by using an 8 digit number asset


      Unfortunately this 8 digit number is not a sequential system generated but manually entered and I have a number of data lines which are same number but not prefixed to make up 8 digit. Because of this they are not linking properly can anyone help with a solution.


      Table 1


      Asset Code         Asset Desc          Asset Value       

      00022500             BMW                     10,000

      22500                    SAAB                     5,000


      Table 2


      Asset Code         Asset Life            Asset Location

      00022500             5 years                  London

      22500                    2 years                  Swansea