LO base: how to create employee health record with multiple tables?

I need to create a comprehensive database for the employees in my company

Naturally I want to only create 1 database containing all the different tables needed. I want to create just 1 table with employee profile (relatively fixed data).

My question is, how do I link all the different tables? I would like to create separate tables for eg health screening (yearly occurence), accident reporting etc

Would this be achieved with different databases or can I just combine everything into 1 database?

Hello,

From your question it appears you are relatively new to both databases and Base itself. If that is the case, you are in for a large undertaking. You may be better off with purchasing something or hiring a professional to do this for you.

You will need to not only learn Base, which is a front end process for databases, but select a database to use with Base, learn that and then learn SQL especially for the chosen database.

The place to start is with the LO documentation for Base found here → LibreOffice Base Handbook. There is also the Getting Started guides near the top of the post and some more database info near the end of the post.

After this, you can begin to think on how to proceed.

Also, to answer your last question, typically a project, such as you describe, would be done in a single database.