You’re offline. This is a read only version of the page.
Announcements
84
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:
https://photos.app.goo.gl/HHeDN46QXE4eR3896
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/2c89f076-7e47-4715-a314-1d4958307dd3 -- 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.
https://photos.app.goo.gl/HHeDN46QXE4eR3896
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.
