I setup an inventory table in FM with SKU, Category Name, Manufacturer Name and Description.
I also setup another table called manufacturers with fields called Manufacturer ID, Manufacturer Name, Category ID and Category Name.
Seems to me that the fields shown in blue can be your match fields for this. Just ad an ID field to the inventory field and set it to look up the ID field from manufacturers. This wouldn't be your "main" relationship, just one used for this special purpose of establishing an ID number based link. You'll ultimately end up with two Tutorial: What are Table Occurrences? that refer to Manufacturers, one for names used as match fields and one that matches by ID's.
See this demo file for an example of the technique and note the scripting added to support what happens when you select a name:
FileMaker 12 users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fmp12
Pre FileMaker 12 Users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fp7
You sir, are a scholar and a gentleman...(if in fact, you are a male) either way...you're my hero. Reading the further explanation on that file put 2 and 2 together for me. Thank you so very much!