title: Append 2 rows from 1 row with unique data in each
body: <p>Very new to Access, thanks for your patience:</p>
  
  <p>I have 2 tables which are records of bridge supports. The supports are numbered. In one of these tables there is one row of information for each support #, lets call it tblSupport. In the other table I would like to have 2 rows corresponding to each support #, each row corresponding to one side of the bridge or the other (e.g. left, right)--lets call the table tblPosts.</p>
  
  <p>I have a form that allows a user to input a record for a new support in tblSupport, including the identifying # for that support. I currently have it so once the info is entered and a "save" button is clicked, it adds the record for that support to the table and appends a row to tblPosts with the same support # so that another user can enter data regarding the posts for that support. </p>
  
  <p>Each time a user enters data for a new support in tblSupport (via a form) and clicks "save" I would like to append 2 rows to tblPosts, both with the same support #, but in another field called 'Side' I would like one row to show 'Left', and the other to show 'Right'. So then tblPosts would be ready for the next user to enter data for both the Left and Right posts for a single Support.</p>
  
  <p>Any tips on how to do this? Please let me know if I need to clarify anything</p>