Greetings all,
I am revamping my database and rebuilding most of it from the ground up so it can be more robust and more user friendly.
I have created a few tables with miscellaneous data just for testing as I am designing everything.
For starters, when creating and defining my tables, I used the "Lookup Wizard" under the Data Type which allows me to select the reference and automatically creates the relationship link between the two.
However, when doing this, sometimes it references a number that refers to the name in the field. As an example, let's say that Company A has an ID of 1, Company B is 2, etc.
When I am creating a query to search for the company name, it seems to be attempting to reference the ID number associated with the company name and the resulting search results are blank because I am trying to search for Company A rather than the number 1.
Is there a way to mask this search value so that it will allow the user to search for the company name rather than the unidentified number?
I hope I explained this thoroughly enough. Those of you familiar with relationships most likely know what I am referring to.
I recall seeing a tutorial related to this in the past, but I cannot locate it again.
Thanks.