Zack Fair appears only within the Final Fantasy VII compilation—no mainline FF titles (VIII, IX, X, etc.).
Zack's story is inseparable from FFVII. He is the emotional anchor of that sub-franchise—not a crossover character.