2 Data Bound List Boxes

[Weste]

I have 2 list boxes bound to a database. The 1st list box displays services
ordered by the customer. I want the 2nd list box to display services not yet
ordered by the customer.

For example. My services are A, B, C, D and the customer has ordered A and B.

List box 1 should show A, B
List box 2 should show C,D

I have list box 1 working. Can someone give me some help as to how I need to
setup the query for list box 2? Thanks for your help.

Weste

[Weste]

RE: 2 Data Bound List Boxes

The query below solved by problem.

SELECT Services.Servic eID, Services.Servic eName
FROM Services
LEFT JOIN (SELECT ServiceSales.Sa lesID, ServiceSales.Se rviceID FROM
ServiceSales WHERE ServiceSales.Sa lesID = @Param1) AS B
ON Services.Servic eID = B.ServiceID
WHERE B.ServiceID Is Null


"Weste" wrote:

I have 2 list boxes bound to a database. The 1st list box displays services
ordered by the customer. I want the 2nd list box to display services not yet
ordered by the customer.
>
For example. My services are A, B, C, D and the customer has ordered A and B.
>
List box 1 should show A, B
List box 2 should show C,D
>
I have list box 1 working. Can someone give me some help as to how I need to
setup the query for list box 2? Thanks for your help.
>
Weste
>