InfoPath Dev

I have an InfoPath form, that is a department request form. I would like to have it autonumber, much like SQL Server does Identity. I'm actually storing all the information from the form in it's own sql server, so technically, I could use the Identity field as the request number - -  So here are the questions: Can InfoPath ...

One last question - - I just tried this on a datePicker control - - in Conditional Formatting, 'Hide this control' is not available - - only Read Only Is there something I'm missing here?

I saw that and I really wasn't sure how to get it to work - - I tried a couple of things, but just couldn't figure it out - - After I saw your post - - I tried it again and realized I was thinking of it backwards - - make it invisible and make it visible if the ddl item was 'Other' When I changed to 'is not equal to' ...

In my InfoPath form, I have a dropdown list with choices to make, and one of the choices is 'Other'. I need to know how to create a textbox which is not visible (or disabled) by default, but ONLY if the user chooses 'Other' from the ddl, then the textbox becomes visible. Is that possible in InfoPath?