Do an insert instead. If you're changing the key it isn't an "edit"
--
David Berry
Microsoft MVP - FrontPage
FrontPage Support:
http://www.frontpagemvps.com/
-----------------------------------
To assist you in getting the best answers for FrontPage support see:
http://www.frontpagemvps.com/FrontPa...3/Default.aspx
-----------------------------------
"Dave Lagergren" <(E-Mail Removed)> wrote in message
news:2DA9A796-6B57-4E0B-BF65-(E-Mail Removed)...
>I have a database I use in FP 2003. I set it up with BDW to include EDIT.
> My only problem is that the EDIT function preserves the index number and
> does
> what it is supposed to, it EDITS the existing record. I need it to write
> the
> edited record back with a new index key instead.
>
> How can I do this?
>
> --
> Dave Lagergren
> Manager - Data Applications
> Wireless Management, Inc
> Specializing in cellular wireless applications