Subject Re: [firebird-support] Record duplication
Author Robin Davis
Hi Michael,

Michael Weissenbacher wrote:
> Hi,
>> Bless you for that simple but effective solution! The only problem now
>> is that the newly inserted record comes up with all fields marked as
>> deleted until you close the form and reopen it - at which point all is
>> as it should be. Any thoughts - apart from getting them to ditch Access? ;-)
> my guess would be that access thinks that the record was deleted because
> the trigger changes the key value "under the hood" without access
> noticing it. How about giving them an editable view of the table that
> doesn't include the key column? Would this work?
Not really, as helen's solution - if I am reading it correctly - still
requires the user to enter a negative value in the PK field in order to