Need help pulling in data similar to vlookup in Excel . . Access Newb :( (1 Viewer)

[morerockin]

Hello All,

Please pardon my level of newb. I hope to learn as much as I can from any help you guys/gals can provide.

Please see attached. View attachment Simple Sample Database.accdb

In my Access Database, for each row, there are two queries I want to pull data from to give me the status of the item in the related columns. In Excel, I use one file with multiple tabs to vlookup the data. How would I accomplish this in Access?

For Example, Jacksonville has a value of “Submitted” in the Completed Checklist Column and “Approved” in the Parts List Column. These values currently come from two separate tables. How do I get my database table to update when the status changes for each of the columns?

Let me know if you have questions or need clarifications.

 

[Galaxiom]

These values currently come from two separate tables. How do I get my database table to update when the status changes for each of the columns?

Sounds like you have a data structure error. Any values in a database should only be recorded in one place.

Research database normalization.