View Full Version : Newbie - Linking Tables to Drop-Down Options


pras_ram
05-28-2008, 07:10 AM
Hi,
I am creating a Movie database.

How do you (1) create a table of Actors linked to a Word or Excel list of Actors?
(2) In your form view - when you select Actor - the 'dropdown' goes to the same list where you can select an Actor?

Does this make sense?

Thanks,
Pras

Fifty2One
05-28-2008, 10:42 AM
(1) Import the Excel list of Actors into an access table

(2) sorry I dont understand the question

Pat Hartman
05-28-2008, 11:03 AM
Once you have imported the table of Actors, add a combobox to your form. As long as the wizards are turned on, the wizard will walk you through setting it up correctly to select and save the ActorID but show the Actor name.

pras_ram
05-29-2008, 01:10 AM
(1) Import the Excel list of Actors into an access table

(2) sorry I dont understand the question


Thanks for your reply on (1)
I got a reply on (2)

Pras