i have a free standing table that i want to create a CANDIDATE index on to prevent dupes. here's the issue, the app requires a blank record. so how do i append a new record to this if i add the CANDIDATE index? i get "uniqueness violated" when i try to "Append blank" at this time.

thnx