Hi, I have an MSSQL db with identity columns to get consecutive numbers. e.g. Invoice object has invoiceID, which my users like to have consecutive numbers. Identity works well for this.
In addition to just having these numbers in this field they also need a string invoiceReference, which will default to the invoiceID but be manually editable on some ocassions. How can I best get the default case to work (where I need to invoiceID & invoiceReference to be auto-generated to the same consecutive number) while having the fewest possible database roundtrips. Thanks, Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
