Creating a self populating check list

[julesverne]

Hello, I'm fairly new to OpenOffice and was wondering if I could get some help creating some forms for work. I am trying to create checklists for solar electrical systems, ideally I'd like to be able to open a document and select multiple terms from a list (for example: fuses, breakers, glands, continuity test, batteries, etc.), and then have those automatically populate a form with the terms and a description of what that term entails. For example if someone selected fuses, glands, and continuity test, they would get a form like:

____ Fuses: make sure fuses are the proper amperage
____ Glands: installed in the proper location and tightened securely
____ Continuity Test: Make sure wire leads have proper continuity and polarity does not cross

Thank you in advance!

[jrkrideau]

I'd suggest taking this over to the Base forum. It seems very clear that the best tool for the job is a data base.

[julesverne]

Will do, appreciate it

[Villeroy]

Database design has nothing to do with OpenOffice. It is the same art you have to master for any type of relational database.

So you mentioned 3 attributes to store. There might be a lot more. I can think of
who? some technichian
where? some project, client, location which required the logged action
when? possibly an (automatic) time stamp
bundles of what? actions could be bundled, e.g. bundle A implies actions x, y and z

Not considering all the items that need to be stored leads to trouble. A relational database is difficult to change once you started populating the structure with real data.

[UnklDonald418]

I uploaded a simplified demonstration database with a 4 tables and 3 forms based on my understanding of what you want to accomplish.
It should give you an idea of how a database might be used to solve your problem.