Wouldn't that be the fifth Land Before Time film? They leave the valley due to the food being destroyed and they venture into the desert in order to cause their herds to stay together. When they see the "Big Water" they initially think that it is drinkable, and guzzle it with unsatisfactory results. Later on, when they are stuck on the island, they want the water to go away so that they can reunite with their families once again.