Do I need to link my tables?

[Melani]

Hi,

I've made a movie database for my dvd collection. And I've made a actors
table and a movies table and a table in between to link them.

How do I link them all together. Isn't there a linking screen I can use.

Thanks in advance

Mel

 

[Rick B]

Not sure how far you have gone, but there is a movie collection databse on
the Microsoft website that you can download.

 

[John Vinson]

Hi,

I've made a movie database for my dvd collection. And I've made a actors
table and a movies table and a table in between to link them.

How do I link them all together. Isn't there a linking screen I can use.

There isn't a "linking screen" sitting there waiting to link your
particular two tables - but you can very easily create one yourself.

Make a Form based on the Movies table (you can use the forms wizard).

Put on it a Subform based on the linking table.

On the Subform put a combo box based on the Actors table to select the
performer.

See the Orders form in the NORTHWIND sample database for an example of
how this can work.

John W. Vinson[MVP]