How to make an interface for web-app that uses 2-3 tables from database ?
Say, one main table, one depending table (updated when 1st table row clicked) and 1-2 images from these tables.
And possibility to edit texts of each selected row of these tables in browser.
What framework are you using for the web app? What is the flavor of database (ie. MySQL) ?
A good hint on images... don't store them IN the table. Store the url in the table (path and image name) and save images as files on disk (in a folder for example).
No framework now, just pure B4J server app with the handlers. SQlite DB, but i think about MySQL. Yes, images are in files, in the table just file names.
And for the operator it's needed the work interface to work with 2 tables comparing 2 images manually editing the DB.