i am using tables customer(Customerid) and project(Projectid)
my req is one project should have only one customer...
i.e, if project1 is assigned to customer1 then it should not be assigned again...but project1 can be assigned to customer2,3,4....
project contains(projectid,projectcode,projectdesc,projname)...projid is primary key
customer contains(custid,custname,custtype)...custid is primarykey...