Personality form without a table?

[Caters]

I am wanting to make a personality form in Base.

I am wanting it to be like this:
Basics(category):

Questions(full response(like for name, general appearance, etc.) and multiple choice(like weight category) and mixture(like illness and if so what illness)

Physical(category):

Mostly full response. Some multiple choice(like for example muscularity index(a scale from -3 to 3 to generalize appearance))

Social:

Mostly full response but some multiple choice and mixture(relationship, children, job if any etc.).

Other(might categorize this later):

Like social but includes things like habits, hobbies, and other less important stuff.

Anyway I am wanting to do this without a table if possible(since you can't have multiple choice above yes/no in a table and I want that).

I already have a table with the most important characteristics but I can't make a table that would potentially have hundreds of questions.

This is for my characters. Now I realize I could program this in something like Python or JavaScript but I want to know if there is a way to do it in OpenOffice. If not then I will code it. You can look at the signature to see what I am using.

[UnklDonald418]

It sounds like what you are attempting definitely would be in the realm of a database. It also sounds like you have some misconceptions about what can be stored in a database table.

(since you can't have multiple choice above yes/no in a table and I want that).
I can't make a table that would potentially have hundreds of questions.

Actually just about anything that can be digitized can be stored in a database table (and probably is somewhere). However, this would not be an easy project.
You might start by reading more about databases.
Here is a link to the Apache OO documentation library
https://wiki.openoffice.org/wiki/Docume ... e_Chapters
in particular
https://wiki.openoffice.org/w/images/3/ ... thBase.pdf
and more up to date user guides can be found at.
http://www.libreoffice.org/get-help/documentation/
There is also a good tutorial on database design at
https://wiki.documentfoundation.org/ima ... torial.pdf

[UnklDonald418]

Upon further consideration you might be able to accomplish that with as few as 3 related tables.

already have a table with the most important characteristics

would be one table.
Another table

that would potentially have hundreds of questions

this would contain all the possible questions and a Primary Key field that would be used to link to a
third table that would contain responses to the questions and also include links to each of the other tables. There would be a one to many relationship from your existing table to the responses table, and a one to one relationship between the responses table and the questions table.
The tricky part would be designing a form that could display all that information, but a table or two on the form might work.