Repeating Panels in Access Forms?

[Ter]

Hi,
I have done some work in Lotus Approach, where you can link databases
and create a one to many repeating panel which displays on a form. You
can also create a many to many relationship by using two, one to many
relationships with a junction table. You can also pull any field from
any of the linked databases to display on the form. I am new to
Access, but I was wondering if you could pull linked data from any
table onto a form. From the little I know, a form is linked to one
table only. I have a video collection where I want to create an actor
form that shows all of the videos that the actor has appeared in. I
also want a "programs" form that shows all of the actors in the
program. I have three tables, Actors, Programs and
Actor/ProgramJunction. I am stuck in trying to show the Programs on
the Actors Form and the Actors on the Programs form. I am using Access
2002. Ter

 

[DevalilaJohn]

The simple answer is subforms. You can create a from for programs that would
be added to an actors form (and vice versa). The data source would be a
query pulling enough data together through the union table. The linked field
between the form and subform (either actor or program) would limit the data
displayed to the appropriate records

 

[Ter]

Thanks!