Multiple key and change

Hi all,

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!

Matt

0 3 108
3 REPLIES 3
Top Labels in this Space