When to stand firm or let kids skip out on plans

Being a parent has its ups and downs, and one of those downs are the tantrums young kids can throw when they don't want to go somewhere. But they're not thinking of the money you spent to get them there, so when do you put your foot down, and when do you let them skep out?