Using Rules instead of sub domain for 2 seperate hosting sites

We have a client that will be using Cloudflare pro for DNS and protection only. They are developing a membership site on one hosting plan and a seperate database independant of the memership site on a different hosting site. The original plan was to have a sub domain members.example.com for the membership site and example.com the database site. They are hosting seperatly, they asked if we could setup page rules instead of sub domains. For example : example.com\members would use the first hosting A record and example.com would use second hosting A record. We want to know if it is possable one and is it feasable. What is the best way to handle two hosting companies on one domain / sub domain…

This has been resolved.