I have one MS Access 2003 DB. I have 2 tables tPatient and tChartLocUpd.
tPatient has many fields but I would like to update 'folderloc' (text) based on when ID in this table matches PtMR data in table tChartLocUpt when they match.
Ex data in tPatient (among other field values)
Ex data in tChartLocUpt (only 2 fields)
After the update tPatient would look like
Also would like to have a basic error check in that if in tChartLocUpt there is a PtMrn that doesn't exist in tPatient (ID) then post a message
tPatient ID = Long Int (autonum)
Folderloc = Text
tChartLocUpt PtMrn = Long Int
ChartLoc = Text
I am not very good at SQL in VBA so help is appreciated!