Help for writing a Query

Hi there at JoomlaPolis,
I have 2 simultaneous problem.
Problem 1
I already have a Dropdown single select field (let's say Field 1) with 10 values.
For some reasons I would like now to add another field (field 2) using specificly only 2 of the 10 previous values. So I would like to automatically populated these values in field 2 from the field 1.
I guess that CB Query function could help, but unfortunately I am not into that kind of thing  .
Mostly this query should say : if Field 1 got value "x" or value "y" then get this value for Field 2.

Problem 2
Because I want this new field 2 being serachable, I would like to have this field as "Dropdown single select" with the 2 values above mentionned.
Is this possibility compatible with my first request ?

Thanks a lot in anticipation for your anser.

You want to dynamically set the dropdown options of Field 2 based off what's selected in Field 1? Yes that's doable with either CB Query Field or CB Code Field either using a Query Select or a Code Select. In your case it's probably best to just use a Code Select and do this with PHP so you don't need to hit the database for information already available since it's user data. Your PHP would basically check if Field 1 contains X value then add Y to an array and return that array.

As for helping with the coding we do not provide coding assistance outside of our Business Membership .