I was wondering if you could help me--i'm trying to perform a query that will search for a grooms or brides surname and then produce the list of items that couple have on their wedding list.

The tables i hve include:
Goods Details: Goods_Id, Categ_Id, Goods_Name,Goods_Desc, Goods,Price, Goods_Make,WeddingCouple#

WeddingCouple: WeddingCouple#,Grooms_Surname, Brides_Surname, DateOfWedding


Basically what i'm trying to is to develop an online wedding list--whereby you can go on the net and search by the grooms or brides surname and it will produce ther wedding list which you can then purchase from.

I'd be so grateful, i've run out of ideas

Many Thanks
ps:i'm using vb6 webclasses

Thanks