Hi Everyone,
I have a scenario where the IDs are unique but can have multiple Parents.
for e.g. A person can be part-time in one Branch and part-time in another Branch
Person ID Person BranchID Branch
1 Peter Williams 1 City
1 Peter Williams 5 Woodhill
2 Steven Hen 5 Woodhill
Branches
---- City
------ Peter Williams ID 1
---- Woodhill
------ Peter Williams ID 1
------ Steven Hen ID 2
I am getting the error "These columns don't currently have unique values" which I understand but just wondering what my options are to cater for my scenario?
The Treeview is for selection only so if someone knows a person is working under a particular Branch they can expand that Branch and select the person. No need to add/update/delete nodes.
Any suggestions will be much appreciated
Thanks
B
I have a scenario where the IDs are unique but can have multiple Parents.
for e.g. A person can be part-time in one Branch and part-time in another Branch
Person ID Person BranchID Branch
1 Peter Williams 1 City
1 Peter Williams 5 Woodhill
2 Steven Hen 5 Woodhill
Branches
---- City
------ Peter Williams ID 1
---- Woodhill
------ Peter Williams ID 1
------ Steven Hen ID 2
I am getting the error "These columns don't currently have unique values" which I understand but just wondering what my options are to cater for my scenario?
The Treeview is for selection only so if someone knows a person is working under a particular Branch they can expand that Branch and select the person. No need to add/update/delete nodes.
Any suggestions will be much appreciated
Thanks
B