adding search in data base

[gwtechie72]

I am having problems developing a database that will search a product by
manufacture or model number. Can anyone explain to me what I have to do in
order to create the search option.

 

[Jeff Boyce]

We're not there. We have no idea how your underlying data is structured.
How you would search depends on what you would search.

We can't tell if you are talking about searching "one-time", directly in the
table, or building a search function for a form, as a user interface.

Are you searching for a known manufacturer or model number? If so, and if
you are working in a form, you could use a combo box based on a listing of
all the manufacturers (or models) -- these would typically be stored in a
"lookup" table.

If you are looking for a manufacturer something like "xxxxx", or a model
number that contains "yyyyy", you could use a query and the "Like" operator.

More specific descriptions will lead to more specific suggestions...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[tina]

as Jeff said:
structured.

you're not telling us anything specific about how your tables are
structured. if you don't know how to design the tables to store the data in
a normalized structure, then you need to forget about forms and everything
else for the moment, and learn the basic principles of relational design
before you do anything else. for more information, see
http://home.att.net/~california.db/tips.html#aTip1.

hth