This sounds like what I call a "Hierarchical Conditional Value List".
See if this matches what you want: (Can't tell for sure from your picture)
You select a value in field 1. This value restricts the values listed from a value list in field 2. Selecting a value in field 2 then restricts what values appear in Field 3.
Not only can this be done, there's more than one way to do it. Some time ago, I created a teaching file on conditional value lists that has working demos that you can examine and take apart along with detailed documentation on how they are set up. several of the demos show different ways to set up a Hierarchical Conditional Value List:
Using this forum search for
or your favorite search engine:
filemaker dwindling value list
There are several articles on FileMakerHacks. Any demos in previous versions can be used with the current version.
There are many techniques to explore. Not all are included in the adventure file but a dwindling value list happens to be one of the methods demo'd in it.
The file also also has a link to a second file that demonstrates additional selection methods that do not happen to be conditional value lists.
Note also that if the main issue is that you want the visible records to update with each change, you can either perform a script that uses perform find or constrain found set each time you select a different value. You also might use a portal to list the records with the value list formatted fields either used as match fields in the portal's relationship or in a portal filter expression.
WOW thank you for the quick responses when I get back from vacation next week I will delve right into the answers.