InfoPath Dev

Well, I knew that I could set a field's value based on a single query of a data connection, I just didn't realize that I could set three different query fields in the same connection. Then I just queried the data, and assigned the annual counter field the default value of MAX([Annual Count])+1 It was quite a bit simpler than I was ...

In case anyone is following this, I did figure out how to perform this query...

Thanks for the reply, Brandon, but I don't think that will do what I hope to accomplish. You see, the counter needs to restart at 1 for the first event of every year, and is also unique to the fields District and Division. e.g. There can be all of the following event numbers in the list: William Penn-North-2012-1 William ...

OK, I'm pretty new to InfoPath and SharePoint. I'm also not sure if this is the correct forum to post this, but here goes... So, I have this SharePoint list and an InfoPath form for adding new items. I've got several DDL's and other fields populated with data - no problem. I need to populate an "Event Number" field ...