Thanks for the quick reply. But Im using Ms-Access where do I put your SQL code
CREATE [ UNIQUE ] INDEX index
ON table (champ [ASC|DESC][, champ [ASC|DESC], ...])
[WITH { PRIMARY | DISALLOW NULL | IGNORE NULL }]
hello everyone, I wanted to know the equivalent for the keyword 'UNIQUE' which is used in SQL to make two columns into a Composite key, in MS-Access.
If you do not know about the UNIQUE keyword in SQL, basically all I want is to make to columns a composite key. Meaning: Just Like if you were to...
Thanks everyone for all your help
I tried Jeremy Wallace's way and it worked. All I had to do was to put them in the same table and restructure the rest of my database's tables and views to keep the rest of the functions working.
Thanks again!
Hello everyone!
I have a really urgent problem. I have 3 tables
_______________________________________________________
Customer
--------
CustomerID
Name
Phone
..
Password
_______________________________________________________
Employee
--------
EmployeeID
FirstName
LastName
..
Password...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.