you need a relationship field at user or/and at author.
because you should be able to query relationship fields in both directions. you can
show users at author page, and show author details at user page (at least if users and authors are CPTs)
but to get it working you need advanced php/ACF/WP knowledge. if you are unable to adapt the example for your needs, you probably need to hire someone to do it for you.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
© 2022 Advanced Custom Fields.