Dropdown List Selection

[djossh]

Hi I'm new to access, I'm currently doing some projects and I dont know how to correct this small Problem (I Think)

I have this 2 tables which are related (One to Many)

(Table 1) with 2 fields only (ListID is my Primary Key)

*ListID---------- FruitsID

(Table 2) with 2 fields also (FruitsID is my Primary Key)

*FruitsID----- NameField
1 -------------Banana
2 -------------Apple
3 -------------Grapes
4 -------------Strawberry

Everytime i enter data (ex. Grapes) into Table 1 (FruitsID Field) an error saying "The value you entered does not match the Number data type in this column. " this is because i need to enter the ID# and not the Name of the Fruits...

How to have a dropdown list of the Fruits in my Table 1 FruitsID field instead of ID#, I want to enter the actual Name of the fruits and not the Number ID.. thanks in advance..

 

[Alansidman]

Are you entering data directly into tables? If so, you should create a main form and then a subform and link them as parent child relationship. Enter all data through forms. Tables should only be used for storing information -- not data entry. This will solve your issue.

Here is a tutorial on subforms.

http://www.datapigtechnologies.com/flashfiles/subforms1.html

Alan