Hi @friendofdog
I’m afraid you can’t do it by using the relationship field. To do it, kindly check this guide: https://www.advancedcustomfields.com/resources/dynamically-populate-a-select-fields-choices/. The guide is talking about the select field, but I believe you should be able to modify it for other fields too.
I hope this helps 🙂