Searching SQL queries and returning Specific Rows

[Trowser]

Hello guys I am back again for yet more help

I am running a query which returns results back to my program then in another part of the form depending on what is shown in the form it has to run more querys to get more details.
hm not sure how to explain this properly
-----------------------------------------------------------
System Component Details

Ram
MB Chipset

Computer Video Ram
Chipset

HDD Size
Speed
----------------------------------------------------------

ok the above is what the form looks like the first query returns the system and the component
then the program reads what the component is goes to the table for say HDD and then returns the results on details of that component.

Now because the program is having to run 4 querys the initial one and then as you browse through 3 others to get the details it is making it quite slow (A few seconds to go from one record to the next)

Now in order to speed this up (I am crap at Access and SQL) I was thinking ok actuall just running 2 Querys and keeping the details open at all times.

The problem is when I have opened a query can I actually go straight to the record for that componant for example
-----------------------------------------------------------
HDD size
Computer Speed
-----------------------------------------------------------
since I will have all the details in one record set already open but it will have the details of all the HDD's how can I search my results (go straight to the row) that contains the details of the HDD that the user is curently looking at?


I dunno if I have made any sence here or made it clear on what I would like to do but I hope one of ya understand. If not I will try to explain better

 

[LazyMe]

Have a look at the JOIN statements. You should be able to get the details along with the first query.

I have no idea what your tables look like but for instance:

SELECT Component FROM tblX INNER JOIN tblY ON tblX.Component = tblY.Component;
Greetings,
Rick

 

[Trowser]

Thanks rick I will have a gander at that