Double Lookup - Microsoft Access Forum


	Back to Access Forum Comments List

Double Lookup

Leo Rivera

2 years ago

I really need help, I have no idea what to do! I have a table of 19 record but each record has plenty other records. I want get a field for a record 2 to my table. Therefore is 2 look up. First look up for the table one and once I got the field I want to do the second lookup using the information of the first look up and make a filter of the second table and record the field in my table. I do not know if I have to do a query or create a table with 2 look up. Somebody have idea? Is there a video can I purchase?

	Juan C Rivera @Reply 2 years ago
Can you do a screen shot and show us what you are trying to do?

	Leo Rivera OP @Reply 2 years ago
I can't is confidential information but is two tables one has titles which is the first lookup and this bring a related field that contain the second table which contain several records of the title of the first table. Once I find the record of the second table I want to save one field in my tables.

	Alex Hedley @Reply 2 years ago
Have you written a DLOOKUP to get the first piece of data?

	Ludwig Willems @Reply 2 years ago
volgen :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen