Sub 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.

 

[Ernie Taylor]

It is much easier to use a combo box on your form providing a drop down box of your films rather than using a + sign to jump to an order table. My suggestion is set up a number of forms: firstly a simple order form containing a combo box of all films.Secondly a form for films which has a combo box of film names with a subform showing the orders for films (create this form from the film table and then add a subform using the order table)- if you get the link correct as you move from film to film you will see who has ordered the film in the subform : Thirdly you could do it the other way around by using a customer form with an order subform so that you can see which customers are taking what films. Have fun with Access it is a great tool. You may find some of the databases provided by the database wizard helpful and the Northwind sample an inspiration.