Relationships in Access 1

[kkadakia]

Hello

I have 2 tables, and i want to create 1 form with the contents of those tables. Can anyone tell me how i can form the relationships between them ?

Also, i want to print a report which will have the contents of the form. But the report cannot be printed unless all fields are filled. How can i do that ?

Any help will be appreciated.

Thanks.

 

[stephenk1973]

Is there a common field/link between the two tables?

Create a query based on both tables, then use the wizard in form module to create a form based on the query.
Then create a report using the report wizard, agains this being based on the query.
Add a button to the form with the wizard turned on and an option to 'open report' will allow you select your report and auto-create the button for you If you only want to print the current record, some filter options can be added to the open report event.

This should get you started, good luck.

Stephen