Ok,
So, I am working on a project where I need to connect a few PCB's together. Basically I have a current sensor that is on a little PCB that may be 3-6 ft away from my main PCB. Nothing exotic here, power, ground, and then signal back from the current sensor (Ratiometric, voltage), no digital data, high clock rates, etc.
So I have been digging through various options from amphenol, molex, etc, but buying cable ends and pins and assembling them all is frankly a pain, and right now we are using screw terminals and we are looking to save some labor time, so doing all that would really not save us much/any time.
What I want is to utilize some sort of off the shelf cable assembly. I want connectors that click/snap into place, as this will be in an environment with a lot of vibration. I was thinking of using something like cdrom audio cables, as they have nice little 4-pin connectors that lock into place, but I need these to be at least a few feet long, and havent seen any longer than like 30cm or so.
There are also some options with JST style connectors, but I haven't really been able to find exactly what I am looking for with these either.
What kind of solutions do you guys use for these sort of situations? I need a cheap solution, so nothing crazy and it needs to lock into place. Are there some other already existing common cables out there that I could utilize for this? I am looking for the cable itself, and then the sockets on both ends which will go onto my PCB's. I would prefer through hole sockets, but if there are some otherwise great options with SMT sockets for the PCB's I am definitely interested.
TIA!
EDIT: I will be buying these typically in lots of about 100.