You should set up a relationship between the related fields in each table.
You can create a subform which is recommended if you have a One to many relationship.
You might have for example Table A comprised of "OrderHeader" with an autonumber field for an ID. This is the "One" side of the relationship.
Then Table B As "OrderDetails" it will also have it's own ID autonumber but also another field eg. OrderHeaderID (number type) that will relate to the Order header table field.
With that established Create a form for Table A
Open the form created from table A in Design veiw, size the sceen so you can see the database window. Click and drag table B onto the form footer of the form. and choose the correct link from the wizard window.
Read the help file for Subforms to familirize yourself There are other ways to do it
Ziggy
