Composite Key

Hello, just wondered if anybody could either tell me the answer or point me in the right direction to the following question.

I have a table that maps Users to Requirements

The following is Valid

Where User = Jon, Bob and Requirements = 1, 2....

User Requirements
Jon 1
Jon 2
Bob 1
Jon 3
Bob 2

The following is not Valid

Jon - 1
Jon - 2
Bob - 1
Jon - 1

So I basically need to know how I can enable the above constraint.

Any help is much appreciated

Jon
Not to worry. Solved it..

complete NOOB hope someone can point me in the right direction

I have been programming access databases for 8 years.
Well today I find out that I need to know SQL.
HUH LOL

well I don't have a clue as to how people even enter data into
a sql database or how to manipulate or retrieve data.

Can someone please recommend a book to get me started?

thank you very much for any and all help with this.sparks (jstalnak@.swbell.net) writes:

Quote:

Originally Posted by

I have been programming access databases for 8 years.
Well today I find out that I need to know SQL.
HUH LOL
>
well I don't have a clue as to how people even enter data into
a sql database or how to manipulate or retrieve data.
>
Can someone please recommend a book to get me started?
>
thank you very much for any and all help with this.

Isn't Access an SQL database? Or since you post in this newsgroup,
you specifically mean SQL Server databases?

SQL Server is a server application that accepts data from clients. Clients
can be implemented in a multitude of ways, both as Windows applications
and web applications. You can write applictions in .Net, in Perl, in VB6,
in Java, in about every language. You can even use Access - this appears
in fact to be a common solution.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog wrote:

Quote:

Originally Posted by

Isn't Access an SQL database?

http://en.wikipedia.org/wiki/Microsoft_Access#Features
One of the benefits of Access from a programmer's perspective is its
relative compatibility with SQL (structured query language) queries may
be viewed and edited as SQL statements, and SQL statements can be used
directly in Macros and VBA Modules to manipulate Access tables. In this
case, "relatively compatible" means that SQL for Access contains many
quirks, and as a result, it has been dubbed "Bill's SQL" by industry
insiders. Users may mix and use both VBA and "Macros" for programming
forms and logic and offers object-oriented possibilities.