Problem with Microsoft Office Access 2003 (077-02871) for PC

Using Microsoft Access I'm creating a database to store my Movies to keep track of the ones i have borrowed to friends. I have one main table that contains a MovieID, Title, Actor, Genre, Rating

and Format. The Movie ID is the Primary key and Genre, rating and format and drop down boxes with data i've already put in coming up. Now I want to be able to enter Actors, preferably 2 per movie, but store it in an Actors table with a Firstname and Surname along with an ActorID. Is this possible? have I explained what I'm after correctly?

Posted by avatar on Sep 07, 2010

Solutions (1)

The easiest way to achieve your goal, would be to use a second interfacing application to hand the database operations. I suggest VisualBasic.

Add Your Solution

See all Microsoft Office Access 2003 (077-02871) for PC Problems