this is a newbie question and may have been asked in some variation previously which I read but didn't quite understand.
So my scenario is the following:
Currently I am running e.g. a TS3Server und the domain myname.ddns.net . I have to tell my friends/newcomers every time "Hey please connect to myname.ddns.net:12321". .ddns.net is a free domain hosted by no-ip without any further features. I am planning to switch to another provider to get a paid, more serious domain like myname.net and have full control over all DNS records. My plan then is, instead of saying "Connect to myname.ddns.net:12321" I can say "Hey connect to ts3.myname.net". The same would be with a mail server, cloud server, game server. E.g cloud.myname.net, mail.myname.net etc.
Why is it that regarding how DNS works, I as an individual can't tell the .myname-DNS-Server to ask my OWN private DNS-Server where e.g cloud.myname.net is located?!
I want my own DNS server because many providers limit the amount of sub-domains available and I don't if it's possible to have sub-sub-domains. Because with Teamspeak I could imagine having my friends connect via ts3.myname.net and have them control e.g. a music bot via musicbot.ts3.myname.net. That's why I want to have full control over how many sub-domains I have.
PS: The comments mention myname.tk which is another domain I registered because I didn't want that .ddns. in the middle of the domain and Freenom which is the company that provides me with myname.tk allows for more sophisticated control over DNS records.