Multiple fields with duplicate options and searching multiple fields at once

December 1, 2020 at 02:31 PM

On a listing, I am looking to include multiple lesson types that a teacher uses. Currently I am looking to structure the fields as shown below.

Lesson type 1 <- single select dropdown list
Lesson type 2 <- single select dropdown list (with same options as above)
Lesson type 3 <- single select dropdown list (with same options as above)

Is there a recommended way to do this when the fields options are basically duplicates of each other? I had thought of populating the dropdown from a database call, but I haven't gotten far yet and if I used "Click to Add" as I originally planned that would complicate things.

I had thought of using formbuilder but because I need these lesson types to be searchable I think that rules it out.

I don't plan to use a multiple select dropdown for the above fields because I wish to include prices with each lesson. By that I mean something like

(field1) Lesson Type 1

(field2) Lesson Type 1 Price

(field3) Lesson Type 1 Length

(field4) Lesson Type 1 Price per Minute

Which brings me to my second question, is it possible to search fields Lesson type1, Lesson type2 and Lesson type3 in one go? By that, I mean rather than search each field individually, search all 3 at once?
I'm playing around with Advanced search at the moment, but if the above functionality exists it alludes me.

Edited December 1, 2020 at 02:34 PM by Ant
Added info

December 1, 2020 at 02:44 PM