VS: [GENERAL] Delete after trigger fixing the key of row numbers

2008-03-28 Thread Teemu Juntunen, e-ngine
Hi Tomasz, with receipt rows I can't see any other option with key as running number. First I tried to use serial, but it didn't start from zero again when the foreign key (receipt number) changes. It just continues the serial despite of the foreign key. Then I decided to do my own serial which

[GENERAL] Delete after trigger fixing the key of row numbers

2008-03-28 Thread Teemu Juntunen, e-ngine
Greetings from Finland to everyone! I joined the list to hit you with a question ;) I am developing an ERP to customer and I have made few tables using a row number as part of the key. Frex. Order rows table has a key of order number and row number like Receipt rows table has a key of Rece