transactionID will remain unique for each record since it is set to auto_increment<br><br>the question is,  is  the table  supposed to hold more than one entry for a singe register? <br>if that is the case then the table is not normalized and a seperate table for registers might be required.<br>
<br><br><div class="gmail_quote">On Tue, Oct 27, 2009 at 11:43 AM, kennedy kariuki <span dir="ltr">&lt;<a href="mailto:kkairu@gmail.com">kkairu@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><div class="gmail_quote"><div class="im">On Tue, Oct 27, 2009 at 11:38 AM, Chris Mwirigi <span dir="ltr">&lt;<a href="mailto:mwirigic@gmail.com" target="_blank">mwirigic@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

alter table <b>table_name</b> add unique (<b>TransactionNo, </b><b>Register);<br><br></b>it will create a compound key that gurantees that only one combination of transactionNo and Register is allowed<b><br><br></b></blockquote>

</div><div><br>Chris,<br>
<br>
how does he take care of the primary key alias???? I presume that would
be the Transaction ID which has to be unique for the composite key??? <br></div></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br>
Other lists<br>
-------------<br>
Announce: <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce</a><br>
Science:  <a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/science" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/science</a><br>
kazi:     <a href="http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general</a><br></blockquote></div><br>