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

[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. Simple Sample Database.zip

I had to zip the file as it was over 500KB

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.

[alansidman]

Why have three tables. It appears that you have redundant data tables which is contrary to the 1st Normal Form. I believe if you normalize your data to one table then you will not have an issue.

Look at this link on design of databases.

http://sbuweb.tcu.edu/bjones/20263/A...sDB_Design.pdf

[LaughingBull]

I changed some things your database I added a form to enter and update records and a report to show the status of the data. in the form you can lookup the site and change the parts and status as they change then run the report to see the status of each site. not sure that is what you are looking for but it was fun. let me know if this works for you

I do not know how to attach the file like you did on here

[morerockin]

Thank you Laughing Bull!!! Can you zip the file and click on advanced post and click the attachment icon and upload the attachment?

[morerockin]

If you clicked on "reply to thread", you need to go click on "Go Advanced"



After you enter advanced mode, click on the attachment button



After clicking on attachment, click Add Files and select the computer from your hard drive and click UPLOAD



After uploading you attachment should show up at the bottom. If it doesn't show up, close the attachment dialog box and reopen it. Your attachment should show up at the bottom. Select it and click INSERT INLINE.

THANKS!!

[LaughingBull]

Simple Sample Database.zip
Let me know if this works for you you will see there are 3 tables the main table and the other 2 are lookups for the main table. to make updates open the form and make changes to the records.

[morerockin]

Simple Sample Database.zip
Let me know if this works for you you will see there are 3 tables the main table and the other 2 are lookups for the main table. to make updates open the form and make changes to the records.

Thank you for trying on this. So it looks like you created a form where you could type in the new status and it will update the table. This doesn’t solve my issue since we aren’t going to spend hours upon hours manually typing in data – we want the tables updated via linked tables and then the new data in the tables to be referenced onto the main table.

Can you let me know if I am asking for something unrealistic?

[LaughingBull]

communicating over text is hard to explain what you are looking to do in my experience. here is my email and if you want send me an email and I will share my phone number and we can talk. ltjy1234@gmail.com
the form I created there is no typing from the top you select the site and the parts and status are drop down list, not sure it came through that way. but what I hear you saying is some one puts in an order and at different stages someone has to go into the database and update the status of what they have done. are the people who take the order and the location of the parts and who accepts or rejects all in the same building? what I need is a complete list of the process from beginning to the end. but it sounds like you need a one to many relationship between the tables
Check out these trainings https://www.youtube.com/watch?v=kKGho0Nhabc
and https://www.youtube.com/watch?v=dZEs-JCkOmk and https://www.youtube.com/watch?v=SmjbZc-Jxgc

[June7]

Somebody inputs data somewhere. How else can the status of a record be set? Where are these 'linked' tables and who input the data?

If you are getting data from another source and want to transfer data to your native table, that usually means INSERT and/or UPDATE SQL actions.

Otherwise, just build queries that join the native and linked tables.

[LaughingBull]

check out this link to build the queries you need to do what you want

https://www.youtube.com/watch?v=3M18nTWjPXg