i have this problem and i don't know what to write to retrive the right data.
i have a view that contains three fileds code,desc,category.
and another table that has the code and a customer no which appears on the screen (the code as a list of value)
to make it more clear:
code desc catogory
aa first mm
ai second mm
bc third lm
i need to see in the list the values that belongs to this customer only.
so if i retrieved a customer no 1 and he is in category mm i should see in the list just aa and ai.