Did you promise your 6 yr old that she was going to go with him and you knew he would be upset?
Next year, you need if she is with you on Halloween, ask her in advance what her plans are and you also need to make plans for your DS to go with his friends.