Showing one-many tables on a form

[benny7]

I'm new to access, so this question might sound simple. However I have two tables, one parent and one child. I want to show the contents of each table on a form. How do I do this? ie:

Film Tile
Film Description
Duration

etc .... Above fields in the parent table

Copy Number
Avaialble
DVD YES/NO

etc .... Above fields in the child table. This could contain a number of individual copies of the film in the parent table.

Thanks

 

[PHV]

Provided you have properly set the relationships simply follow the form/subform wizard.
Feel free to take a look at the Northwind database.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244