Of course you will likely need code this, rather than building data access through the interface.
Consider looking into that.
I was just looking for a similar requirement. I am newbie to GWD. Since this post is 3 years old, wanted to check if this feature is now added into GWD. I am planning to use GWD as a front end web UI for backend JDBC compliant database. Please let me know if that is possible with GWD.
Thanks
Rathnam