J
JayStar
I want to prevent duplicate records being inadvertently created, such as same
date, time, name, total hours, - these being critical fields in a larger
table. I run a "find duplicates every month" and remove the duplicates but
I'd rather it didn't happen in the first place. I tried using the unique
grouping of these fields in the "index" option in the table, but it didn't
work, even putting that in I could create a new record copying the data from
the previous record and the database allowed it. Also, how can I make a
pop-up warning message, if a duplicate is inadvertently attempted? Many
thanks
date, time, name, total hours, - these being critical fields in a larger
table. I run a "find duplicates every month" and remove the duplicates but
I'd rather it didn't happen in the first place. I tried using the unique
grouping of these fields in the "index" option in the table, but it didn't
work, even putting that in I could create a new record copying the data from
the previous record and the database allowed it. Also, how can I make a
pop-up warning message, if a duplicate is inadvertently attempted? Many
thanks