Hi,<br><br>My database table looks like this<br><br><b>TransactionID</b>         <b>TransactionNo </b>         <b>Register</b><br>1                               23/2009                     Probate<br>2                               23/2009                     Administration<br>
3                               25/2009                     Finance<br>4                               26/2009                     Strategy<br><br>TransactionID is the primary key and is autogenerated. A register can only hold a unique TransactionNo though different registers can share the same TransactionNo. Is there a way that I can make TransactionNo field to be unique, and is there a way of coming up with a Primary Key Alias to represent the unique TransactionNo for each Register?<br>
<br>Regards.<br><br>Ouya Obunga<br>