title: Default column values from another table
body: <p>How would you create a table where a number of the columns have default values that come from another table?</p>
  
  <p>For example, I have a table that holds some data, and then another table that holds the foreign key for the previous table and columns that can hold similar data to the first table. I want to be able to create a 'snapshot' of rows from the first table where all the date is input be default.</p>
  
  <p>Thanks.</p>