I have recently been fiddling around with Base from LibreOffice trying to learn more about the software and how to utilize it best.
I want to make a running log that not only adds my accumulated mileage when entered into my Workout Info but also one that allows me to track how much mileage is placed on each pair of shoes. For instance if I run in a pair of flip flops for 2 separate 10 mile runs and sneakers on a separate line for 5 miles the Workout Info table would look like this:
Is what I would like to do even possible in a database structure? Would I be better off just going to an Excel Spreadsheet?
Would I use a function or formula to achieve this? I can only seem to add 1 relationship between tables and I believe that is a normal limitation? I attached a current structure of my relationships, my creation of a relationship between my WorkoutInfo mileage and Shoe Mileage, and the error message that the new relationship causes. Am I on the right track with my current structure? Any guidance is greatly appreciated and thanks in advance for the help.
You are creating a database to track how much mileage you have put on your shoes?
Just put it in an excel spreadsheet.
Thanks you blindman. I guess I just really wanted to work with base to create a database and learn the system. I made this more complicated than I had to. I'll find some other use to experiment with it then.