Unique field duplication problem

[matlark]

This seems like such an obvious problem it must have been covered
somehwere, but I haven't found it.



I've inherited a number of multi-user, related FMP6 files. One file
contains a field which I have made unique, and this works fine - no one
can now enter a duplicate value in this field. However, duplicate
entries are allowed when you duplicate a record. So you can get around
the validation of the field simply by duplicating an existing record.



How can I stop this?



Thanks



Mat.


--
Posted via [url]http://dbforums.com[/url]

[Rob van den Brink]

If it is an identification-field, you can auto-enter a number, letting it
increase with 1, 2, 10, 1000, whatever you want. Duplicating a record will
result in a duplicated record, with a NEW serial number.

If it is not an id-field, you can have it auto-enter "" (making it blank)

With kind regards,


Rob van den Brink

> From: matlark <member40285@dbforums.com>
> Organization: dBforums
> Newsgroups: comp.databases.filemaker
> Date: Thu, 18 Sep 2003 22:41:24 -0400
> Subject: Unique field duplication problem
>
>
> This seems like such an obvious problem it must have been covered
> somehwere, but I haven't found it.
>
>
>
> I've inherited a number of multi-user, related FMP6 files. One file
> contains a field which I have made unique, and this works fine - no one
> can now enter a duplicate value in this field. However, duplicate
> entries are allowed when you duplicate a record. So you can get around
> the validation of the field simply by duplicating an existing record.
>
>
>
> How can I stop this?
>
>
>
> Thanks
>
>
>
> Mat.
>
>
> --
> Posted via [url]http://dbforums.com[/url]