Order Form

[MikeUK]

For my A-Level project I have been asked to complete a database using Microsoft Access. I have decided to base my project on a film mail order company. I have been having trouble completing an Order Form. In this Form, there are 3 Tables involved. The "Customer Table", which includes information about the customers, the "Film Table", which contains information about the films available, and the "Order Table" which will contain information about the customer and the "Film ID" number of the film ordered. I have included a "Film ID" field in each table, and there is a "One-to-one" relationship between them. In my order form I would like 2 tables to be shown. The "Customer Table", which will be shown in a “Columnar” format. The "Film Table" will be shown in a “Datasheet” format. I would like for the relationship between the "Film Table", and the "Order Table" to be shown.
I.e. the + sign shown on the "Film Table".
Then by pressing the + button on the “Film Table” I would be able to fill in the information for the “Order Table”.
I am unable to include the + button in the form. I would be very grateful if could you tell me if it is, and how it is possible to include the + button in my “Order Form”, and if there is an easier way to complete the form.

 

[Cedwards]

go away

 

[peters]

It sounds like you need to be using sub-forms inside of a main form.

The sub-form would contain your Film Table and the main form would contain the customer table data, the two would be linked some how, such that when you select a certain customer, the sub-form displayes the film data for that customer.