I have a site that I'm hosting with DreamHost (sitename.com); I want to create a subdomain (gallery.sitename.com) that will be hosted with another company. The main domain is for the public; the subdomain is going to be used for a large, art image database that is using Filemaker. A select group of art dealers will have access to the subdomain in order to choose works to be placed in their galleries. It's important that the URLs be similar, and it just makes sense to create a subdomain for the image database.
My question is: is it possible to have a subdomain point to another host? If so, can someone tell me how to do it?
I tried to do it where the domain is registered, Network Solutions, but in order to access the advanced DNS tools I have to switch the DNS to Network Solution, which I don't want to do. Any help or insight will be greatly appreciated. Thanks