I am astonished how difficult it is to do such a trivial task in other authoring tools: use a texture with transparency. Absolutely maddening!!
Attempt 1
In Photoshop a texture with dots surrounded by transparency. Note the (should be unnecessary) alpha channel added as a vain attempt to appease the Unity gods:
In Unity
WHITE DOTS!?! Useless. Fail
Attempt 2
Convert to PNG and import to Unity. This forum does not allow more pictures - WTF? - so I cannot show you the results. I get a nice texture with dots and transparency but the material ignores the transparency and I get dots on white. No way to force the issues. FAIL.
Can someone PLEASE provide a bulletproof solution. Super frustrated.