How to Create a Microsoft Access Form Based on More Than One Table

You can view or enter data into multiple tables using one form. For example, if you are a potter, you could create a form that shows information from both your Galleries table and your Pottery table. Forms showing data from more than one table are called "flat." These instructions apply to MS Access 97.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

1. Use the F11 key to open the Database window. Click on the Forms tab.

2. Click New. A dialog box appears.

3. Select the wizard that you want to use. In this example, we will use the Form Wizard.

4. Click OK.

5. Select the tables and fields that you want to include on your form. Click Next.

6. Select how you want your data to be viewed. Click Next.

7. Choose your layout. Click Next.

8. Select your style. Click Next.

9. Name your form. Click Finish. Your form is now ready to be used.

Tips & Warnings

• Forms can also contain other forms ("subforms"); these are called "hierarchical. " Forms containing a button that calls up another form are called "synchronized" forms.
• You can create a multiple-table form manually as well.

[muritaiwo]

on 3/1/2007 I am Adewale, studying Information Technology and International business. I have a work on creating a microsoft access database on drug history of patients in a hospital. I am strugling with the tables to use because all the tables seems to not working on entity relationships.
Here is tips:
I need patients information table, patient drug history, patient provisional records, Doctor's information table, and Doctor's medical clerking table.
Please can you give me a guideline on the primary keys to use for each of these tables so as form an entity relationship between them.
My email address is: [e-mail]
Thanks for your time and assistance.