I am having different people fill out the different fields describing a building. The primary field will be a unique identifier. Since each is using a different form, is there a way to merge the records together on the unique identifier?
Otherwise I will have as 2 records.
Building Identifier: A, Color: Brown, Height: Tall
BuildingIdentifier: A, Size: Big, Width: Narrow