Welcome to the forum.
It sounds like you want to create a value list based on values in a field. The dropdown list would then be based on that value list. Have you tried that approach yet?
Thank YOU SOOOOOO much
i make a all of my own layouts mostly simple
but it sure makes my business better