Manipulation of lists in Access

[strive4peace]

Hi Syed,

create a cross-reference table:

*MovieActors*
MovieID
ActorID

If you have a min fiorm for Movies, then create a subform based on
MovieActors. MovieID will be a hidden field in the subform and ActorID
could be a combobox that gets it RowSource from the Actors table

Likewise, you could have a mainform for Actors and use a subform based
on MovieActors with ActorID hidden and MovieID as a combo getting its
RowSource from Movies

I am assuming you have an autonumber field in your Movies table called
MovieID and you also have an autonumber field in your Actors table
called ActorID

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Syed Zeeshan Haider]

Hello Everybody,
I am using Microsoft Access 2003 on a WinXP SP2 machine.

I have two tables. One has a list of movies and other has a list of actors.
Any movie in a "Movies" table can have multiple actors from "Actors" table.
In the same way, any actor entry in "Actors" table can have multiple movies
from the "Movies" table. I cannot figure out how to join these two tables.
One idea that I came up with is giving an Actors filed to "Movies" table and
a Movies field to "Actors" table. Both of these fields would actually be
list boxes. However, I cannot figure out how to make these fields
synchronous to each other in a way that one update in one filed causes the
update of the other field. Any alternate ideas or any ideas to improve my
idea?

Thanks!