Do I need to link my tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Not sure how far you have gone, but there is a movie collection databse on
the Microsoft website that you can download.
 
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.
Click to expand...

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]
 
Back
Top