Hi, I'm brand new to MS ACCESS and I am using MS ACCESS 2007. I would like to make a drop down list of different animal species for an animal shelter database. The list is no problem but I would like to have a unique ID# appear when a specific species is selected. For example if someone clicks DOG then a ID# would appear that begins with the letter "D", CAT would have an ID# that begins with "C", Bovine=ID# begining with "B", etc. Then I would like to use the unique ID# for a listing of each species in a Report.

Is any of this possible? I'm thinking this is a VBA script but not sure if it might be a SLQ script? As a newbie I can create a table with a progressive ID# list but cannot figure out how to give each item a unique ID#.

Thanks,
John S.