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