reneeccwest (reneeccwest@hotmail.com) writes:
> I plan to create a table with 3 unique keys.
>
> Combination of three fields has to be unique for each row in a table that
> are vendor ID (char 8), vendor name (char 40), and vendor office (5).

It sounds funny to me that the vendor ID alone would not be unique.
OK, I can envision that a vendor has several offices, but several
names?

And if a vendor can have several offices, you should probably have the
offices in a subtable.

And as "Mystery Man" said, make that vendor name varchar(40).


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp