Create your tables in your favorite database.
Generate an application from these tables using Seam-Gen (see Seam reference doc, there is a chapter on this)
Study the created application, I believe it will come quite close to what you want to accomplish.
Import the generated project into Eclipse and fine tune it to to suit your needs.
Hmmm... I'll definitely have to do some more reading then, as I didn't really expect Seam-generated app to be similar to my requirements.
Anyway, I'll follow your recommendation and give it a shot.
Thanks for reply, Ingo.