Nancy use INSERT - SQL Command instead APPEND BLANK.
>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
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst