I have a dropdown called 'builderDropDown' that returns 'BuilderName' from my Supabase table 'Builders'. I need to obtain the correct 'BuilderID' from the 'Builders' table when the 'builderName' is selected from this dropdown, so i can use it to filter another dropdown.
Please also provide instructions for use.
I have asked this previously and not understood the answers - so be kind and explain the steps required