You are here:

Using MS Access/Relating Tables on a Form

Advertisement


Jeff wrote at 2013-11-04 18:39:25
Wouldn't it be a many to many as one actor could be in several different movies? I was contemplating doing this myself and I was thinking of using a movie(DVD# table, and actors table, and a third translation table#cast) containing the primary keys from the other two tables which should create a unique key for that table.


Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


Rob Henderson

Expertise

I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions. I also have expierence in application design for all the Office components (Excel, Outlook, etc).

©2016 About.com. All rights reserved.