I am converting an Excel workbook into an Access database. This first tableReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11862-createing-look-up-field.html
I created was an import of all the original data call it Sales Table. I
want a few of the columns to have a limited set of choices, so I created a
table called Region Table. I created a relationship from the Region Table
to the Region Field in the Sales table. However, when I try and create a
lookup table, it deletes the records of gives me an error indicating I am
putting in an unexpected value. If I go to the Sales Table and select fromReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11862
the pull down menu, then it accepts the value. Since I have thousands of
lines of data, I don't want to go through each record and re-select the
correct region. Is there a faster or easier way to make this work? Did I
do something wrong on the import or creating the relationship?
"...God hath made me to laugh, so that all that hear will laugh with me."