Validity/Conditional Drop Down Lists in Base

Creating and using forms

Validity/Conditional Drop Down Lists in Base

Postby cstoll » Wed Jun 14, 2017 5:06 pm

I have been researching this, and have seen that what I want is possible in calc, but I haven't come across any topics for this in base.

I'm creating an artifact catalog for archaeology in anticipation of some large upcoming projects.

What I would like is based on my first field of "Artifact Type" (historic, prehistoric), to then have other fields drop down list options change accordingly.

For instance, if 'historic' is chosen in "Artifact Type", in the next "Subgroup" field, I would like the options to be kitchen, architecture, transportation, furniture, etc.
If 'prehistoric' is chosen in "Artifact Type", I would like the "Subgroup" dropdown options to be lithic, ceramic, fuel, etc.

Thank you in advance for any help. Please let me know as well if this is only possible in calc. I was hoping to use base for the query abilities for analysis, but I'll switch to calc if necessary.
OpenOffice 4.1.3, Windows 8
cstoll
 
Posts: 1
Joined: Wed Jun 14, 2017 4:57 pm

Re: Validity/Conditional Drop Down Lists in Base

Postby Villeroy » Wed Jun 14, 2017 6:59 pm

Macro driven: https://forum.openoffice.org/en/forum/v ... 83&t=46470
Free of macros: https://forum.openoffice.org/en/forum/d ... p?id=27954
The clean version works in the same way as "power filtering". Search this forum for "power filtering". It involves a filter table with a numbered record to store criteria values that are used to filter form contents or list box contents.

My latest "power filtering" example: https://forum.openoffice.org/en/forum/v ... 10#p416210 technically it is very similar to the cascading listboxes.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26410
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Forms

Who is online

Users browsing this forum: No registered users and 1 guest