Access question regarding lookup fields and entering data directly into tables.
Posted on 2013-05-21
I'm new to Access, and have been understanding the program fairly well. But I've run into a dilemma. I'm using queries to populate combo boxes to make entry into datasheet view faster and more consistent (I'm not currently using forms to enter the data). So in table design view, I'm setting the type for the field to short text, creating a query to another table which has the categories I want to select from, and all is well.
But I'm reading that I shouldn't be doing it this way. But the alternative is entering info via primary key ID in some other table and of course there's no way to tell what numbers are associated with employee names, company names etc. Furthermore, some of my lookups have no started returning numbers (primary key ID's i'm guessing, since something has failed with the look up) instead of the associated information.
So how do I resolve the phantom numbers where readable info once was issue, and also, how do i circumvent this problem without using a lot of forms. This DB is just for me and one other person, both of which are IT staff so making a lot of pretty forms seems like an unnecessary project. Thanks!