I'm trying to create a table so that when you enter data, its a pull down menu so you just select when you want instead of typing it. For example, the Fields are Movie, Actor and Movie Genre and for Movie Genre, you can then select Science Fiction, Action, Comedy, Romance, Horror, etc... which i typed in another table.
Set up the table with the fields that you want in it and create a form that is linked to the table you want to enter data into. In the form you can create a combo box that does exactly what you are looking for.
I'm trying to make a database of all the computer video cards. Yes, I am trying to make the tables sources for the combo boxes. In the final table, i just want to be able to have a combo/drop down menu under Manufacturer, DirectX, buswidth, pipes and interface so i can just select them instead of typing them which would reduce errors