Is there a way that I can create a drop down window or something similar where I can select an item but have the field populated with different data. I have a report that I do bi-annually and it calls for a lot of data. If I could automate some of the entry it would be an extreme time saver!!
For example, If I could use a drop down window and select a building in our school district and have it populate with the building code numbers, that would be wonderful. I also have instances where a field requires a yes and that data should be populated with a number 1 or no and it should be populated with a number 2. I also have a field that requires a degree level, a high school diploma is assigned as an 01; an Associate Degree an 02; a bachelor's degree an 03; a master's degree an 04 and so on. I have many instances where a solution to this would save so much time. I am not an advanced learner so if it is way difficult, I may not be able to handle it....any help or suggestions would be so appreciated tho. Thanks.