Pulling info from one table to another again

[roxannep]

I don't think I explained my question well enough the first time. I have been able to have Contacts.EmailName pull over onto a subform used for transactional data. However, when I move to the &quot;table&quot; view of Transactions, the Contacts.EmailName doesn't come across into the Transactions.EmailName column. The relationship between the two tables is Contacts.ContactID=Transactions.ContactID (one to many). <br><br>The transfer of the Contacts.EmailName to the Transactions.EmailName doesn't come across into the Transactions.EmailName column on the Transactions table. <br><br>I'm assuming I have to set it up in the design view of the table since I already have it showing up on a subform without a problem, it just doesn't make it into the table view! I was originally told to put the instructions into an Event Procedure (after update), however, I don't see how that's done in the table view which is where I need this to occur. HELP! <br><br>I realize it's probably quite simple (which are usually the items I struggle with compared to the more complex issues!).<br><br>Thanks to any response!

 

[DougP]

How are you doing this with code or what?<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.