I have a SharePoint list which has a drop down column called PM No - This is a list of numbers ranging from T1 to T200.
Each T number relates to different machines. I want to have the option, for when the user selects any of the choices in the 'PM' column, then the second 'Machine' column filters based on the T number.
For example, If T1 has Machine A and Machine G assigned to it, when the user selects T1 in the 'PM' column then the 'Machine' column will be filtered to only show the two options of Machine A and Machine G.
In the past I used InfoPath forms to create a filter, however SharePoint online no longer supports InfoPath. I have searched online extensively and can't seem to find an answer that fits this scenario.