>Can you post SQL SELECT statement of that view?

Thanks you Vlad and John.
here the sql created by the view designer.

SELECT Price.*, Service.desc, Garment.desc;
FROM clnrware!price INNER JOIN clnrware!service;
INNER JOIN clnrware!garment ;
ON Price.garment = Garment.id ;
ON Price.service = Service.id;
WHERE Price.service = ?pv_service;
AND Price.garment = ?pv_garment