Thanks for the response however I quickly realized that the switch wasn't going to get the job done. I'm now using a router instead.
Let me explain the purpose of this endeavour.
Running an ethernet cable from one side of my residence (from the primary wirless router with internet access) to the other in impractical. I've discovered that the switch solution as well as most dual-router setups require this.
I often deal with large file transfers between my devices and don't like doing them over the wireless network, partly due to speed, partly due to the connection occasionally dropping.
So allow me to try and verbalize this picture and hopefully someone can tell me if I'm being ridiculous or not. As I said, the purpose of this endeavour is to NOT have to run a cable from one side of the residence to the other.
Network 1: internet access
Cable modem -> wireless router -> my computer via wireless card
Network 2: local wired network
wired router -> my computer & multiple devices
internet access is NOT required on this network
So I'm asking if Windows 7 is able to connect to both networks at once? One network using my wireless card for internet access while using the ethernet port to connect to a 2nd router to enable file sharing between devices.
As I was asking in my original post, will toying with the subnet masks etc be required?
Since the local wired network will not directly interact with the wireless network will I still have to set DHCP ranges separate from that of the primary router?
Will my PC be able to deal with 2 separate LAN IP address without flipping out and giving me a blue screen?