[Resolved] Select Where Statement

Classic Servoy
1

I have a project_to_activity relation but I only want the related records with a type_id of ‘2’ to show. How do I do this?

Thanks in advance.

2

Try making it a global relation.

make a global variable : globals.type_id=2

and then add this to the relation (globals.type_id = type_id)

Regards,

3

Damm. Can’t you make it more difficult?

Thanks, worked a treat.