title: How to use RecId as a foreign key in a form
body: <p>I have a table of items that each reference one other item in another table.  We'll say the items are people, and the related items are favorite foods.</p>
  
  <p>Table A:  Bob:1, Sally:1, Sue:3</p>
  
  <p>Table B:  1:Apples, 2:Bananas, 3:Oranges</p>
  
  <p>The "people" are tied to their favorite "foods" by the food RecId, refererenced in the People table.</p>
  
  <p>I have a form/grid for editing people.  Is there a way to cause the FoodRecId StringView in the grid to convert its value so the RecId numbers are not visible in the grid?  </p>
  
  <p>I've already written multi-column lookups to easily handle creating correct relations, but if the RecIds in the grid could be hidden/replaced, the form will be much easier to use.</p>