Originally posted by JHausmann
Originally posted by LISATOMAN
1.CategoryDetails:
Categ_ID(number),Cat_Name(text)

2.GoodsDetails:
Goods_ID, Categ_ID, Goods_Name, Gods_Desc, Goods_Price, Goods_Make, Goods_Pic, Grooms_Surname, Brides_Surname
Number, Number, Text, memo, currency, text, oleextract,text,text

3.OrderDeatails:
OrderNo, FirstName, second name etc(just address details)

4.OrderLines
OrderNo, Goods_ID, QTYOrdered, Price
Number number number currency

5.OrderNumber
LastOrderNo
Number

Speak to you soon
In order to exclude items from selection, you'll need a table that contains all items(GoodsDetails only contains a subset of all possible items for order) for laughs, I'll call it "GoodsMaster". It then becomes a simple matter to exclude prior selected items by doing a sub-query. For example:

sSql= "select * from GoodsMaster where goods_id not in(SELECT * FROM GoodsDetails WHERE Grooms_Surname LIKE " & "'%" & _ strKeyWord & "%' or brides_Surname LIKE " & "'%" & _ strKeyWord & "%'" " ORDER BY Goods_ID)"
The problem is i need to search for grooms surname and brides surname and the date of the wedding to produce one name so that it is unique?

CAn you send me your e-mail address and i 'll show you the code it'll be easier that way. Thanks time is [email protected]. Much appreciated