I have a row labeled 'MRNum_ClientID' computed as ([MRNum]+CONVERT([varchar],[ClientID],(0))).
I was on another forum discussing how I could make it so my users couldn't enter in a duplicate record in my program I've created in Alhpa Five. It was suggested to "make an index" and then SQL would return an error. How do I go about doing this? In my program the user types in the MRNum (medical record number) and ClientID is automatically populated.
Bottom line is 'MRNum_ClientID' must always be unique.