>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
HI-YO SILVER AWAY!!
The Lone Ranger, The late Clayton Moore R.I.P.
I am a fool!