Thank you for the quick responses guys! Hmmmmm, I can't get either of these to work, let me pose another problem I am having with my data that is very similar, it may help: Table 1-LineItem Detail, Table2-Contract Category. The 2 tables link from a SKU field where Table2 will look up the SKU from Table1 and return either - CORE or CATALOG. I want to be able to use a list box with selections of: CORE/CATALOG/NON-CORE, where NON-CORE is everything where the SKU in Table 1 is not found in Table2. Any ideas!? Thank you!
If you just want to lookup a value from table 1 in table 2 and get another value back - Core or Catalog, you could use a mapping load of table 2 and use applymap() function in table 1 with a default value of 'NON-CORE'. Please refer to the manual for all details.