Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Amir88

    UNIQUE equivalent

    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 }]
  2. Amir88

    UNIQUE equivalent

    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...
  3. Amir88

    Autonumber Problem

    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!
  4. Amir88

    Autonumber Problem

    Hello everyone! I have a really urgent problem. I have 3 tables _______________________________________________________ Customer -------- CustomerID Name Phone .. Password _______________________________________________________ Employee -------- EmployeeID FirstName LastName .. Password...

Part and Inventory Search

Back
Top