>Hi James,
>
>I used the form wizard to create the parent-child form.
>Sorry, but still a little confused. You write:
>
>You could set a unique index on the field and handle the error, or you could build a routine to query the value before the save is attempted.
>
>Could you show me an example on setting up a unique index on the field??
>
>Thanya

index on myfield tag myindex unique

Or you could create a candidate index. If this field is the primary key then define it as primary. All three approaches will ensure uniqueness.