All Microsoft Lists have a primary key column which, by default, is called "Title". Sometimes, the primary key needs to be something else, like 'EmployeeID' and column that is actually named "Title". This is the case with a Microsoft List we have for my company. The primary key (the thing normally called "Title" according to the microsoft coding) appear in bold text. Here, "EmpID" is the primary key column:
In order to make sure I was able to make a duplicate of this list, by copyig it to a CSV file to later import it (I could not do it the adviced way suggested on this page https://answers.microsoft.com/en-us/msoffice/forum/all/duplicate-a-microsoft-list-with-contentdata/2... -- which I will explain later) I thought I would rename these two columns so that the automatic import process would go smoothly. But even if I only asigned the "Title" column to "Data" things did not go smoothly.
But even though neither of these columns were named "Title", once I assigned "EmpID" to be a title type during the import phase, Microsoft List renamed this column "Title". And so I renamed it to its proper name "EmpID" which worked fine.
The problem happened when I wanted to rename my "Data" column to be called "Title". Eventhough therer was not another column named "Title", I got an error stating that there was already a column named "Title". Is "Title" a key word in this software and one cannot use it to name a coumn unless it is a primary key of the List database?
If this is the case, how did the original Microsoft List get made?
We are haing some issues with the original Microsoft List and maybe, if "Title" is supposed to be a reserved word, then this List is corrupted and this is why we are having issues.
As for not importing the List the advised way, when I tried to open the .iqy file, there was a message to enable or disable embedding for the images. No matter what I picked, the import process crashed.
@Rob_Elliott Somehow, and I don't know how, my boss created a Microsoft List where EmpID was used as the Title of the Microsoft List. That first screen shot is from that Microsoft List. Adjacent to that column was a column where the display name was, somehow, "Title" whilst it did not behave as if it was the actual (hidden name) Title. I know that the EmpID was the proverbial Title of the List because, as the screen shot shows, the contents of the list are bold.
You can say that a List cannot have any column named TItle, without it functioning as the Title column, but somehow my boss did it before I got hired.
