At this time, I'm calling my id generator a couple times and checking after the fact for duplication. I've thought of a couple different ways to do this better.

1) split the identifier into parts, call the id generator for the individual parts and then concattenate them.
2) concatenate a machine name identifier with the generated id

#2 is easier and it gives an immediate track of where a part was processed, but it you use all digits, you need to include some logic to eliminate duplicates when they coincide ie: 23 + 24 = 2324, 2 + 324 = 2324

Hope this helps


>Hi
>
>I Read this thread#236192 because i also have this problem(record disapear with Transaction) but i only have this problem with my child table.
>
>At this time do you Find a solution ???
>
>>Did you ever reach a conclusion or a solution to the problem? I read this entire thread with growing enthusiasm as you describe a situation I've had 3 times in the last 2 weeks. You never say if you found a decent solution or put it in Microsoft's capable hands.
>>
>>thanks
>>