Database

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)

kripa ostwal wrote:

I have car entry screen, in which user can insert a car details such as number, color, model etc. & amenities (select multiple for 1 car).
Now search screen, when user selects aminities from list., I want to show only those cars who have all selected amminities.

kripa ostwal wrote:

where ammCode in (2,3)

SELECT c1.carCode
FROM carAmm AS c1
INNER JOIN carAmm AS c2 ON c1.carCode = c2.carCode
WHERE
c1.ammCode = 2
AND
c2.ammCode = 3