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. Karen -----Original Message----- From: Lin MacDonald <[email protected]> To: rbase-l <[email protected]> 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]. 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.
