Hi
Only just learning Access 2016 and setting up a first basicdatabase at work to play / learn but stuck already and would appreciate anypointers please.
There are only 2 tables so far Requests & GP List. User would enter data to the Requests tablevia a form also called Requests.
Both tables have a field called PCode and I am trying to automaticallypopulate part of the form (from the GP List) after a PCode is entered.
User enter a data into a field called PCode on the requestsform and then I want Fields called Practice Name & Telephone to pull throughfrom the GP list table
I think I needed toset up a relationship and have done (screenshot) and then trying to code an after-updateevent but cannot get anything to work! Can anyone give me any pointersplease? I have tried some code from theinternet but no joy and not sure if the relationship is necessary or set upcorrectly