Ok, I think Kiwiman is on the right track with the Dlookup feature. But I still cannot get it correct.
The structure of the database:
DATA FROM THE FIRST TABLE TABLE: Listings
FIELD: Property Root Folder ***This is a path like "C:\6850 Dustin Circle\"
COMMON FIELD: Listing ID ***This is...