I’m at the stage where I need to reach out to ask for some guidance into - what is likely to be - a fairly simple problem.
- I have a financial Accounting System which can output data in a specific format.
- I want to take that data, clean it up a bit and append it to an existing Access DB – Using VBA where possible - For enhanced reporting purposes.
- The Access table has a foreign key field, and the incoming data must have a corresponding valid key value in order to maintain referential integrity during the append process.
- I am trying to use the DLookup function to fetch the value of the primary key based on a match between two String Values in both tables. (In this case ‘Building Number’)
- What I’m trying to get DLookup to do is display the primary key value in the second table, using a match between Building numbers to determine the value of the foreign key.