Reports (1 Viewer)

[Mirae]

I checked through the postings and did not see this one. I need to create a report on a small church library's holdings of video tapes. I need to list them by topic. A video can be on more than one topic. How do I get a report that shows all the topics in alpha order with the videos listed below? Example: A Topic of FAITH would have the same video as a Topic of WORKS but would be far apart in the listing. Thanks.

 

[Pat Hartman]

You have a many-to-many relationship and need three tables to properly represent it.
Video, Topic, and VideoTopics.

tblVideo contains a unique identifier (usually an autonumber) that you can use as the primary key, a title, and other information that pertains to the video.

tblTopic contains the standard Topics you have defined.

tblVideoTopics is the relation between Videos and Topics and contains just two columns - the primary key of the Video table and the primary key of the Topic table.

Use a MainForm to enter Video information with a subform for VideoTopic information.