Validity/Conditional Drop Down Lists in Base

Creating and using forms
Post Reply
cstoll
Posts: 1
Joined: Wed Jun 14, 2017 4:57 pm

Validity/Conditional Drop Down Lists in Base

Post by cstoll »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Validity/Conditional Drop Down Lists in Base

Post by Villeroy »

Macro driven: viewtopic.php?f=83&t=46470
Free of macros: download/file.php?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: viewtopic.php?t=88516&p=416210#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 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply