title: Copy Field contents from one Table to another table - FileMaker
body: <p>I am new to Filemaker pro. I am working with Filemaker pro 13.</p>
  
  <p>My database contains 3 tables: </p>
  
  <ul>
  <li>category (fields = _pkCatID &amp; CatName)</li>
  <li>subcategory (fields = _pkSubcatID , _fkCatID &amp; SubcatName) </li>
  <li>books    (many fields including _fkSubcatID)</li>
  </ul>
  
  <p>I have no problems in conditional value lists, so making two popup menus in books layout for categories and subcategories was successful.</p>
  
  <p>But I want to put both categories and subcategories in one menu/sub-menu using 2empowerfm Menu Popper plugin.</p>
  
  <p>I created a new field in subcategory table to store a calculation to be used in the value list of the plugin.
  The calculation is = CatName &amp; ">" &amp; SubcatName &amp; ";" &amp; _pkSubcatID .
  So the returned value when choosing in books layout will be "_pkSubcatID".</p>
  
  <p>The problem is CatName is not in Subcategory table, and if I choose it from the related table Category, I can't make the calculation "stored" which is a requirement to use a field in a value list. </p>
  
  <p>So, I need to copy the field CatName from category table to a new created field in subcategory table. I don't know how to do it.</p>