using Subforms

[Gman1950]

In a subform how do you connect two tables so that when you enter information from one table it will automatically generate the other

 

[David McQueen]

It depends on the source data for your subform.
Some possible solutions

1. You can create your subform based on the two tables ( for really basic stuff use Form Wizard and amend accordingly)

2. You can base the data on a query (union or otherwise) which combines and updates the relevant table

3. You can base the subform on one table and have a query which is triggered on the "On Exit" event procedure of the subform.