My app will allow staff to log their working hours.
So I have a table with StaffID / Date / WorkSiteID / HoursWorked.
So far nothing complicated.
In order to avoid duplicated entries, i created a computed_key with StaffID / Date / WorkSiteID
So far so good.
However, when an entry is entered, I cannot change it afterwards…
I do not know how to avoid duplicates and be able to change it afterwards.
Many thanks in advance for your returns!