Unfortunately, my mind has stacked right now and i would like to design a really simple DB schema.
What i want?
In a simple table, for instance Table1, there are two different columns, Series and Orders.
I would like every new record for Orders be unique for Series.
Series: A Orders: 1,2,3,4,5,6
Series: B Orders: 1,2,3,4,5,6
If the user try to insert Series A and Orders 1 for second time i would like to have an error.
I think that the best way is using stored procedure? Am I right?
Thanks in advance.