I need help with form dropdowns

https://jmoster3.wixsite.com/rememberthem/firefighter-emt-submission-form

If I connect my dropdown this way, I get all possible causes of death listed in the collection, and the value is captured in the database.

If I do it this way, I have the filtered list that I want, but it does not save in the database.

How do I get a filtered list based on the HeroType containing “Firefighter” and also have it save to the Fallen Heroes dataset?

Any help would be much appreciated.

Have a read of the Wix Support page for dropdowns and this process here.
https://support.wix.com/en/article/adding-and-setting-up-a-dropdown-list

You should not have both used, if you want the connect to a list option then you need to be leaving the top connection option blank as in not used.