Database

SELECT CONTACT.FIRSTNAME, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.USER2, first(EMAIL.ADDRESS)
FROM dbo.CONTACT CONTACT
inner join dbo.EMAIL EMAIL on CONTACT.CONTACTID = EMAIL.CONTACTID
GROUP BY CONTACT.FIRSTNAME, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.USER2
ORDER BY CONTACT.LASTNAME DESC

SELECT TOP 1 CONTACT.FIRSTNAME, CONTACT.LASTNAME, CONTACT.COMPANYNAME, CONTACT.USER2, EMAIL.ADDRESS
FROM dbo.CONTACT CONTACT, dbo.EMAIL EMAIL
WHERE CONTACT.CONTACTID = EMAIL.CONTACTID
ORDER BY CONTACT.LASTNAME DESC

SELECT *, 
    (SELECT TOP 1 dbo.EMAIL.Address
       FROM dbo.EMAIL 
      WHERE dbo.EMAIL.ContactId = dbo.CONTACT.ContactId)
  FROM dbo.CONTACT

I are troll

SELECT     * 
FROM tblWeb_E_Catalog_Categories 
WHERE ((Active) = -1)

or

SELECT     * 
FROM tblWeb_E_Catalog_Categories 
WHERE ((Active) = TRUE)

or

SELECT     * 
FROM tblWeb_E_Catalog_Categories 
WHERE (Active = TRUE)

Ebube wrote:

i develop my application backend on ms sql 2008. but my client is using 2000

Ebube wrote:

should i script all the database object( tables, storeprocedures .e.t.c)

Ans: Only 1. Not only in MSAccess, in any database i.e. Oracle, Sql Server etc. It is a general database rule.

You can have many FK and Composite keys however.

Yes.

      Primary key constraints
      Foreign key constraints
      Check constraints
      Check constraint expressions
      Unique constraints
      Default constraints

A little search in google gave me the second answer

<a href="http://office.microsoft.com/en-us/access/HP030838791033.aspx">http://office.microsoft.com/en-us/access/HP030838791033.aspx</a>[<a href="http://office.microsoft.com/en-us/access/HP030838791033.aspx" target="_blank" title="New Window">^</a>]

pk = New ADOX.Index
pk.Name = "PK"
pk.PrimaryKey = True
pk.Unique = True
pk.Columns.Append("TheKeyColumn")
ADOXtable.Indexes.Append(pk)