How to create a work order form similar to my old Paradox Db form

Tkapp · August 21, 2023, 5:20pm

Hello,
I’m coming from the old Paradox DB world and need some help understanding how to make a new work order form in LO Base.

In Paradox we have a work order db that consists of only three tables:
Main_work_orders.db
Names.db
Subject_Category_List.db

The user who needs work done would open the form with a password. That password would determine what fields the user has modify or read only rights.

They would then enter the first seven fields: Work Number, Date, From, Subject Category, Subject, Urgent or ASAP, and then exit the form.

The Maintenance department would open the same form but with a different password. The password would restrict them where they could only read the above seven fields.

They would complete the work and then enter the remaining four fields: Completed, Date Completed, Maintenance Notes, Completed By, all in the same form.

The Names and Subject Category Db’s can be modified by the administrator, which restrict entry in the Names and Subject fields.

How can I do this or similar in LO Base.

Tu
Tom

RobertG · August 21, 2023, 5:24pm

This isn’t possible in Base with the internal databases. You will need a database with user management, something like MySQL/MariaDB, PostgreSQL, Firebird server … Then you could allow user to see different tables. You will be asked by Base to connect to the database with a special user name and user password.

Villeroy · August 21, 2023, 6:04pm

Connect a Base document to your Paradox-DB via ODBC or JDBC.

Tkapp · August 21, 2023, 11:50pm

Okay, I did a little research and know I must install MySql to get the security I want.

Robert and Villeroy,
Paradox is thirty years old. I’d like to stop using it all together. Can you suggest how to setup tables/form to accomplish a new Work Order Form for employees.
I don’t know LO Base and some first step suggestions would be greatly appreciated!
Tu
Tom

RobertG · August 22, 2023, 9:17am

Have a look at Base Guide 7.3. There is a “simple” database described step by step (page 30 up to 72). It will help to start to create tables, to create forms, to create a query and to create a report.

After you have tried a little bit with this example we could see which problems still appear.

Tkapp · August 22, 2023, 10:41am

I’ll check it our, and am sure I’ll have more questions. Thanks again!

Villeroy · August 22, 2023, 1:10pm

The Base Guide describes the creation of an embedded HSQLDB. “Embedded HSQL” is one of the two database types Base can create from scratch. This is a single-user database because it is embedded. Once you have the database backend (tables, indices, relations) up and running, you can convert the embedded database to a stand-alone HSQL database outside the Base container which supports priviledges of groups and users.
Finally, you may run HSQL as a server application for simultanious multi-user access.
I’m not sure how much Base can help you to generate tables, indices and relations of a MySQL database. I would expect that you create the whole backend with some MySQL administration tool before you connect a Base document to that database and add the frontend (queries, forms and reports).