Thank you! That was exactly what I was trying to do!! Lin
On Friday, September 9, 2016 at 5:52:59 AM UTC-7, [email protected] wrote: > > If I understand what you need, you want to define a Unique key based on 2 > columns. That way you cannot > enter a 2-column combination that already exists, right? > > Take a look at my print-screen (isn't it awesome that we can do this > now??). Go into RBDefine, key/index, > new key. Add both EpNo and SetNo as your columns. On the next screen, > choose the radio button > "Unique Key" at the upper left. At the bottom of the screen you'll see > your table name and the 2 columns. > Modify the error messages if you want. > > [image: rbase.png] > > > Karen > > > > > -----Original Message----- > From: Lin MacDonald <[email protected] <javascript:>> > To: rbase-l <[email protected] <javascript:>> > Sent: Thu, Sep 8, 2016 5:52 pm > Subject: [RBASE-L] - Multi-Column Index - How to build, implement etc > > Thank you all for the help last weekend. I have run up against a new > snag. I hope this will make sense... > > I have a table that should be indexed on two numeric columns: EpNo and > SetNo > -there can be multiples of the same EpNos in the table but only one > combination of the same EpNo and SetNo > -the same SetNo can appear many times in the table, but only once per > EpNo > > The way it is currently set up, if I enter a duplicate SetNo, I get an > error message (that it needs to be unique) if that number exists in the > table, even if it exists with another EpNo. > > This is an existing application, with data in it. Is there a way to work > around this issue, or a better way to do it? > > thanks, > > Lin > > > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
