Making a database to search based on any category...

[fiel]

I'm trying to make a database that would store Program Codes. What I'm trying to do is that in the end I will have a form that can search code on any category. These categories would be: Type, Description, Version, Area, Author. So far I only have 1 table that stores all this data but am experiencing somewhat of a "writer's block". Perhaps anyone could lend me a few pointers? I tried setting a seperate table for each category, setting it as a primary key and setting a relationship to the main table with all the information, but it won't let me update or edit my data. Any ideas?

 

[PHV]

Have a look here:

http://r937.com/relational.html

http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886