Thank you David for correctly pointing out:- > Perhaps the better question for you to be asking is what software > would best meet your needs in creating a form that will interface > with sqlite's db back end.
That is precisely the question I should have asked (should I start a new thread?). OOI Visual FoxPro, not only allows you to create forms to insert data into the database, it also has the facility using its "BROWSE" mode (like a spreadsheet with columns and rows) to specify rules for each column; so that you can do things like:- - force UPPER case. - set MAXIMUM/MINIMUM values. - LOOKUP and retrieve data from another table. and being spreadsheet like you can see and edit previously entered values. The reason I'm trying to get away from FoxProw is that I wish to move over to Linux and there appears to be no fully relational database equivalent available in Linux. I've tried OpenOffice Base but that does not appear to tick all the boxes. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
