Ask Your Question
0

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

asked 2019-01-23 05:32:56 +0100

Ian Bong gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-01-23 05:54:53 +0100

Ratslinger gravatar image

updated 2019-01-23 05:58:25 +0100

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-01-23 05:32:56 +0100

Seen: 37 times

Last updated: Jan 23