Create the MovieRented
Table
The
MovieRented Table stores all of the numbers (Keys and Dates) that
were selected in the Form and Subform.
3.
Try it: Create the MovieRented Table
Go to
Create ->Tables->Table Design.
Add the
following Fields and Data Types:
MovieRentedID |
AutoNumber |
ReceiptID |
Number |
CustomerID |
Number |
MovieID |
Number |
DateRented |
Date/Time |
Try This,
Too: Create the Primary Key
Select
MovieRentedID.
Go to
Table Tools->Design->Tools.
Click on:
Primary Key.
Please, Do
This: Save the Table
Go to
File->Save.
Enter a
name: tblMovieRented.
That's two
Tables. Close tblMovieRented.