Huge apologies if I’m asking somehting idiotic! First time poster…
I run a charity and want to enable our volunteers to update their own contact info and details such as next of kin etc.
I know there is no way to edit information in my main table.
But can I set up another table which I pull data from using a lookup and have that lookup only pull the most recen information ie. if I am Jo Bloggs, I submit my next of kin details on a form. Something changes, I then submit another form and the first one is negated by this later additon?
Thanks in advance for any help offered.
Very best, Nathan