5 Replies Latest reply: Nov 2, 2011 5:24 PM by Jasleen Puri RSS

    Problems with text/num format

      Hi, I  have a problem with a application, and I don´t understand why.

       

      I want to add a new table and create a key between the new table and an existing table, using a field productID, a 16 digit number, ex 1002344001022349.

       

      Even though the exact same productID-numbers exists in both of the tables they don´t seem to connect.

       

      My guess is that the format of productID is different in the two tables. But even if I try using num(productID) or text(productiD) it still doesn´t work.

       

      Can anyone help me figure out why this is happening?

       

      Thanks!