I did not create the table; I just have to modify. I'm assuming that both of my fields are automatically incremented when a new record is entered. I was thinking that that just required a seperate sequence and trigger (for solnum)...there are ones already for the primary key (empnumid). Would that work?
>On 1/16/07, Nick G <[EMAIL PROTECTED]> wrote: >> >> I hope this is not a newbie question...I'm not much of a DB person. I need >> to update or modify a table to make two fields to be unique (empnumid and >> solnum). The empnumid is the primary key and there is no foriegn key. Thanks >> for taking a look! > > >An unique index would work if I understand the question correctly. > >Just a point of reference though, I know empnumid means something to you, >but you might be better off being a little more explicit with your table >definition. It makes your db structure easier to remember and understand >for years to come. employee_id (assuming that empnumid is employee >something or other;) makes more sense when you are looking at it than >empnumid. Although, maybe that's just my own way of looking at things. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2679 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
