Help With Searching Database

[adenwalker]

I have built a basic database to hold details on all my computer books and software as i hundereds of them.

I have built a table with text, number and memo fields which i want to be able to search.

What i would like is a form where you can enter details into various fields (eg Title, Author, a field to search all fields, etc) and then display the results in a table in the form below it. Then when the record is double-clicked it opens the record ina new form displaying more details.

Is there a way to do it as i have spent months trying to figure it out and trying to include the sample databases?

I have attached my database so any help will be appreciated.
Thanks,
Aden

 

[Len Boorman]

Basically what you want to do is okay except that you cannot have a field to search all fields. Also your field Keywords will give you a problem. You have set this up as a memo field which if memory serves is not searchable. Keywords should be a separate table with a link to the main table. Also Price is duplicated across two tables. The price applies to a copy surely. When you have only one copy then it is copy one.

Suggest that you review your tables and ensure they are normalised before going further.

Then set up a form with combo boxes for the items you wish to search on. If you make these cascading you should find that searches become simpler and more meaningful

Len B

 

[Mile-O]

I took your two tables out - as they were no use - and replaced them with a number of tables.

If you don't understand why, after taking Len's advice on normalisation, then please ask.