Juan,

Your request needs more info. What are the different types and how do they relate to the ID numbers? What kind of indexing do you have? A compound index on Record ID + Type? Or separate tags for each?

Be a little more descriptive and we'll try to help you come up with a good quey.

Ok... I have the database, this database has Five (5) tables.

The main table is called "proyect"
"proyect" has the field "number" as the key field
"number" is used to identify the number of the proyect....

but the thing is that Now There are different types of proyect, There could be...

PS, RC, RDC, RCONC proyects,

for example: PS 0001, or RC 0001, "they can have the same number but different types of proyect"
PS = Type_P = type of proyect
0001 = number = number of the proyect

So I made a new field in the table called "Type_P" to put all of these.
So in the form i can select in a combo box what kind of proyect I am doing, and then add the number.

I also made a table to store the different kinds of proyects so I can relate them in the main table.


What I want to do is query a specific Proyect, but I would have to query or search for example if i want to query PS 0001, or PS 0004, or RC 0001

I have to tell the search... to search Proyect type PS and has the number 0001 for example.



the other tables I use as options in the form For combo boxes and stuff.

Hope you understand this... Juan,, If you need better description.. just let me know.