I am trying to simulate a DLookup in Visual Basic. What I have is an Adodc link to a table with part numbers in my own Access db. I need to look up values associated with each part number from a tbl on our network. I created a second Adodc connection using ODBC to the tbl I needed on our network. Is there a way to relate the two connections? I want to view related data in ODBC linked tbl to part numbers in my own Access tbl, say in a Change event.
Can this be done? Any help would be appreciated.