I'm writing a MySQL database, hosted on a Linux server (Ubuntu 12.04) and was intending to use OpenOffice Base on a client machine to act as a front end for data entry.
That's fine for editing a single table. But it turns out that in OO a form based on a query which references more than one table can only be used to view the query, not to edit the underlying data. That's just an inherent restriciton of OpenOffice as far as I can tell.
So I've been looking for alternatives. Searching yields plenty of advice about DB management GUIs (MySQL workbench, kexi, glom, toad, heidi etc) which are all great but don't give a simple way of creating a form for data entry that general users can understand.
I can design the database OK (using phpmyadmin/workbench/OO-Base) but just need a way to finish it off with a nice user interface.
1.Can you recommend any open-source equivalent (that will enable editing of multiple tables via a single form)?
2.Should I just give up and make do with multiple sub-forms in OO as a workaround?
3.Am I looking in the wrong direction - would there be easy interfaces in Drupal, Wordpress or equivalents to interact with the DB?
4.Or do I just need to buckle down and learn some php coding :-)
Thanks for your help!