A search query to find and display records...i think it should be easy (1 Viewer)

[bengy]

I am currently creating a a simple database for a warehouse location system. The warehouse is full of boxes of ceramic tiles, each of which have their own name and location.
eg White 20 x25 : location - A21

So all I have is one table, with all the names of tiles and their location and the type of tile they are.

All i would like to do is create a search box where the user can type in the name of a tile and the result will display the locattion of the tile in the warehouse. Also, would it be posssible to have it so that , for example, if there are 2 tiles with names, "Beige Armaghan" and "White armaghan", then typing in "Armaghan" will display the location of both those tiles. Also I would like it to be case insensitive if that is possible.

I think this will be easy to do, but I don't have the time to figure out how to do it...any help would be welcome

Thanks in advance!

Ben

 

[DW]

If you have two types of Armaghan you should set your table out as follows.

[Item] Armaghan
[Colour] Beige
[Size] 6x4
[Location] Shelf 3

With your table set out with single text descriptions, your can use three or four list box,s side by side.
The first will contain Armaghan or whatever descriptions are in the table.
The second list you can refer to the prev list and so-forth.

I use this in a vehicle database,
[Ford] will produce
Escort
Mondeo
Ka

and any other models related to ford.

You must requey the lists to show the most current information.

Dave

 

[bengy]

Thanks for that quick reply..I thought I might have to do something like that.

That's fine but how do I actually create a search box/button? DO I simply create a select query based upon that table and type the qusetion in the criteria field?

Thanks

 

[DW]

You first list box will show all the descriptions, seeing as all fields are singular, you can group them soif you have 3 Armaghans, it will only show up once, but the list to the right, will show two, White & Beige.

Heres an example attached.

 

[bengy]

sorted it

Thanks for your replies and the attachment...

I have now solved the problem using a wildcard search in the criteria of the query...I saw it in an earlier post

Thanks