Multi select search

[simba]

I have a resource table(pic 2) connected with a contacts table (pic 1). When I make an inner join, I get the results that of pic 3.



I want to make a search based on 3 catogories from the above query. My results get populated in the list box, but it is showing phone, fax, tty, hotline as each individual record. How do I make a selection based on the office phone only and on double clicking, the relevant form should open up.

Can anyone help me out?

Thanks in advance.

[Robeen]

Hi Simba,
Did you ever resolve this or get any help on it?
If you still need help with this, could you please rephrase your problem with a little more detail to make it clearer what help you need?

[simba]

Thanks Robeen for your offer of help. I had to use the cross tab query, for which I got help from a different forum.