Hi,
Suppose someone with little Dataverse experience (that is, me!) created an Employee table, then it'd be an easy mistake to make to put the actual employee's name in the "Primary Name" column. All is well - until you get a duplicate "John" or even "John Smith", even if you set a key as an autonumbered field "Employee Number".
So - suppose I now create another column in the table which isn't the Primary Name field, and called it "Employee Name"; what goes into the Primary Name column and how do I manage this? I'm assuming it can't be left blank?
thanks
Martin