Query three values into one field for easy search

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

I have a database about technical books. Its nearly
completed but I'm stuck, I need to search for a book by
using the information that the book might hold.
I.e. "product". Each book has about 3 different product
information in.

I've tried sub form, (combo and list box) but they can't
be put into a continuous form and the one to many
relationship doesn't resolve the predicament.

I have even created 2 more fields so I
have "product", "product2","product3" in the main table
and tried searching for them in a query but the search
isn't accurate

Query code: (like ""&[enter product]&"*") on each product
criteria

If this is the best way I need a query to prompt 3 times
about products in the book searching all three values? Is
there a better code for this in the query? (simple coding)

I need to keep this database size small as it is linked
with Companies main database so it can sometimes become
slow to use.

Like usual I'm making it harder than I needs to be but I
think what I'm asking is how do you put 3 values into 1
field in a Query/ Table format?

Many thanks
Adam
 
Adam

Don't. If you find yourself "committing spreadsheet" in Access, you
probably need to revisit your normalization.

What I take from your description is that a book may have one or more
"products". That sounds like a one-to-many relationship from the "book".
And if the "products" are common across multiple books, you have a
many-to-many relationship

You can create a new (resolver) table something like:

trelBookProduct
BookProductID (autonumber, primary key)
BookID (foreign key, from tblBook)
ProductID (foreign key, from tblProduct)
 
Back
Top