AnsweredAssumed Answered

Converting Numbers to accomodate relationship

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


Converting Numbers to accomodate relationship



     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