Hi Anson,
I have a SP custom table that was the Product Codes and Descriptions. When you select the drop-down list for the Product Code it then initiates a rule that populates the Description field using the "Set a field's value" by using a "Filre Data" where Product Description (Secondary) (Product Code(secondary) = ...