title: how to add rows to more than one table at same time?
body: <p>I have four tables each with its own form, all these table share same column which is the unique id. How do i update other tables when i add new row in one form at same time, that is how do i get a row in other tables with unique id and other columns being empty?</p>
  
  <p>Is there a way to specify more than one control source to the unique id field?</p>
  
  <p>I tried the approach in making one to one relationships between unique id in one table to other tables unique ids But this did not work.</p>