Data entry form like MS Access

(1) By Julian (jrickards) on 2022-09-15 16:32:52 [link] [source]

I'm looking for a data entry form creator for SQLite that is similar to MS Access.

I'm running Linux (Mint).

My FilmPhotoRecords database is quite simple, 3 tables. Data entry into the first (FilmTypes) table is easy and can be done from the most basic of SQLite dbBrowser screen. Data entry into the second (FilmRolls) is mostly simple but it does require a tie-in to FilmTypes so that I can record that roll R0021 is Kodak Gold. The Frames table is mostly easy but it requires a tie-in to the FilmRolls table so that I can record that the frame I'm recording is from roll R0021.

Ideally, I'd like it a bit more sophisticated in that in the Frames data entry form, when I select the film roll, it displays the film type (but I can't edit film type, just see it).

I know that all of this is possible but I'd like nice data entry form for Frames that does all of this.

What can you recommend?

(2) By Holger J (holgerj) on 2022-09-16 12:10:46 in reply to 1 [source]

LibreOffice Base is something you might want to try.

Of course you can also write an application using Java (Swing, SWT, JavaFX) or Tcl/Tk or C++ (WxWidgets, Qt).

Or give a Web application a try. Lots of tools there.

Basically, SQLite works well with all of these, but creating an application is way beyond what a database can or even should do.