I had placed this thread in another forum but I don't think I was making myself clear as it is most likely a coding solution. I have attached a drawing to assist in the explanation.
I need a user who has no coding experience to be able to update a maintenance table(tblAgency) in the front end...