> Here's my query:
>
> SELECT DISTINCT Tools.[Tool Number] as [Tools/Tool Number], [Order
> Entry].[Tool #] as [Order Entry/Tool #], [Order Entry].[Part Number1],
> [Order
> Entry].[Part Number 2], [Order Entry].[Part Number 3], [Order Entry].[Part
> Number4]
>
> FROM [Order Entry] INNER JOIN Tools ON ([Order Entry].[Part
> Number1]=Tools.[Tool Number]) Or ([Order Entry].[Part Number
> 2]=Tools.[Tool
> Number]) Or ([Order Entry].[Part Number 3]=Tools.[Tool Number]) Or ([Order
> Entry].[Part Number4]=Tools.[Tool Number]) Or ([Order Entry].[Tool
> #]=Tools.[Tool Number])
>
> WHERE (((Tools.[Tool Number]) Like "*" & [Search Criteria] & "*"))
> ;
>
> What I think this is doing is looking through the Tools table under Tool
> Number, and through the Order Entry table under Tool #, Part Number1, Part
> Number 2, Part Number 3, Part Number4 and searching for matches with the
> Search Criteria string. It's supposed to search for matches in these
> fields
> of these two tables with the search string that I input. I just wanted to
> make sure that this is doing what I think it's doing and that I'm not
> overlooking something. Can anybody tell me?
>
> I'm also interested in integrating this search query into a form that will
> bring up the matches for verification, and if there are none, provide a
> way
> to add new records to the Tools table. Any idea?
>
> I'd also like to know if this posting makes any sense to you at all...
> --
> Why are you asking me? I dont know what Im doing!
>
> Jaybird