Jeanne Boyarsky wrote:You are in the right forum. I'm not clear if you want to generate the value based on the other fields or a unique value. Either way, most databases support both.
Should I use a stored procedure, that when a transaction is created, the transaction id column is automatically populated?
Thanks
Jack