Welcome Guest, Not a member yet? Register   Sign In
Make table with two record unique
#1
Wink 

Hello
I have below table
[Image: 2lny1s3.jpg]
In this table we can add
sUsername: omid
sProductID: 1
----------------
sUsername: omid
sProductID: 2
----------------
sUsername: omid
sProductID: 1

in high record i add two same record
Actually i need that insert unique record in table
Username and sProduct can be duplicate
But we cannot have two same record

example :
sUsername: omid
sProductID: 1
----------------
sUsername: omid
sProductID: 2
----------------
sUsername: jack
sProductID: 1
----------------
sUsername: jack
sProductID: 2

In high record different record for each username
Reply


Messages In This Thread
Make table with two record unique - by omid_student - 12-16-2017, 12:03 PM



Theme © iAndrew 2016 - Forum software by © MyBB