[KLUG Members] database programming question

[bill]

On Tue, 2004-06-22 at 13:34, Adam Tauno WIlliams wrote:

> Of course I doubt his FileMaker app addresses any of these issues.

Therein is the gist of my point.  None of the points you raised are
relevant now, the only problems stated are poor layout and unnormalized
relational db.  The current system is Filemaker and a non-programmer,
non-database person knows it is not well designed.  Yet, this very
person has to fix it.  Hence, what is the most likely thing he can use
to do that?

That's why I argue for an HTML interface, programming server-side (PHP),
and easy RDBMs(MySQL).  With these a novice can find a ton of help to
make that happen.  If they were answering auditors as you describe, they
would have been stomped for using the current app long ago.  Using those
components (LAMP) he is quite likely to be successful.

BTW, I share your laments over Javascript.  It was fabulous to use, but
that was several years ago before MS made it incompatible among
browsers.  They're determined to force active-x down people's throats,
but security issues are their comeuppance.   I design almost exclusively
without client-side scripting now (I'm even slow to script
auto-submission of forms!).  But, I still wish we could do -some-
client-side (how 'bout spell check?)

kind regards,

bill