Sounds to me like you are dealing with a database so my suggestion is to
use Base, LebreOffice's database program?
There is a tutorial on Writer, Calc, Impress, Base, Draw and Math.
This is for Writer. The column on the right list the others.
gofree.com/Tutorials/LibreOfficeCreateEdit.php
This may not give you the answers you are looking for. Spending sometime
looking at these tutorials to see what each program does, then spending
time going through the tutorials of the ones you do use, will be time well
spent.
Like someone said, Writer is in over its head in maintaining a database.
Like me, not knowing what you don't know, we all go down that path
everyday.