AnsweredAssumed Answered

Converting Numbers to accomodate relationship

Question asked by MikeEdwards on Dec 23, 2013
Latest reply on Dec 23, 2013 by WBSimon

Title

Converting Numbers to accomodate relationship

Post

     Hello,

     I'm having a bit of trouble. I have two separate table with nearly identical data they are joined by two text fields Part number and Revision. I use text fields because often there is text in a part number or a revision. The problem is that these tables come from different sources and the problem arises when one source will call a certain part # at revision 2 and the other source describes the revision as 002 then they do not join. How can I either 2 to 002 or 002 to 2 to get a match?

      

     Working in FM PRO 12

      

     Thanks

Outcomes