hello,
i am using MS Access as back end. my table structure is
{ SId (number),
PId (number),
Qty (number)
}
i want make SId+ Pid as unique,i.e combination of this both key should not repeat.
i.e
1, 1, 5
1,2, 5
it should be accept.
but
1,1,5
1,1,12
should not accept
how should be this done?