InfoPath Dev

 I have four different Content Types (Construction, Facility Lease, Equipment Lease, Carryover) and four different forms all going to a single Form Library. One of the field name projecttype for Construction gets promoted to SP2010.  For Facility Lease, there two fields Lease Category and Lease type. I want to merge Lease Category and Lease Type (ex. Facility Lease, New) to a single field and want it to be populated under projecttype Column in the SharePoint Form Library.

Is it possible?

Hi SRAEngineer,

If you are using a Library, I would suggest concatenating the fields within the InfoPath form and promote this field at the form options. You can also do the same if you are submitting data to a SharePoint list, or add a calculated column (calculation based on other columns in the list). Hope this helps.

Regards,