Base - double dropdown filter

[giovannispitale]

Hello everyone,
despite googling quite a bit I did not manage to sort this out.

So, I am using Base as a frontend to a MariaDB database.

The situation is as follows:

• I have a “module” table (containing one index and 4 text columns)
• I have a “category” table (containing one index, one reference to “module” (text) and 4 text columns)
• I have a “topic” table (containing one index, one reference to “module”, one to “category” (text) and 4 text columns)
• I have an “experience” table (containing one index, one reference to “module”, one to “category”, one to “topic” (text) and 4 text columns)

I need to create a form for “experience” display the following:

• a dropdown menu listing all the existing modules (from the “modules” table)
• a dropdown menu listing all the categories assigned to a given module (from the “categories” table")
• a dropdown menu listing all the topics assigned to a given category (from the “topics” table)

The content of these three fields should be then written in the respective columns of the “experience” table (along with the text columns, but that is easy).

How do I build such a filter/form?

Thanks a lot,

Giovanni

[Ratslinger]

Hello,

The needs section is questionable. It appears:

(from the “categories” table)

appears twice and one may be incorrect.

Regardless, it also appears you want dependent list boxes - the list in one is based upon the selection of another. Is this correct?

If so how are your LO macro skills? This would require specific code for your form/tables.

[giovannispitale]

Sorry, my mistake, the topics are listed from the “topics” table. I correct the original post.
Precisely, I need dependent list boxes.
I know what macros are, how to use existing macros and -theoretically- how to create new ones, recording or writing code. But I never did it.

[Ratslinger]

Example code is in each of the samples as noted in my answer. As stated, this need to be written specific to your form(s) and table(s).

[Ratslinger]

Hello,

Based upon the information provided, it appears this is about progressive list boxes and the resulting selection(s) to be entered into another record.

Please see my answer in this post → Filtering dropdown boxes in base, Table control. The answer contains a link to samples which depend upon whether the entry is using individual controls or a table control.