Forum Discussion
Saving multiple values for lookup column in CDS
Hey everyone! Am currently using CDS as data source for my project. I have two tables Table 1- Projects Table 2- Contractors.
User can select multiple contractors(lookup from table 2) for a project from gallery and the same is getting patched in back end.
But, when user creates a new project, and selects same contractor as previous project, the previous project name is getting replaced by new project name in backend. As it is lookup column and not choice field I am not getting any workarounds. Please help me asap!
Yes I have two tables named Project and Accounts with Many-to-Many relationships. So if I create a Project for first time with a account then there is no error but for the second time with same account, the first project is getting replaced with the second one.
This problem got solved when I created a transactional table and linked the two project and account tables with it. Well thanks for the reply!
Warm Regards,
Sowjanya Matadh
2 Replies
Syndicate_Admin
I am a bit confusing, do you mean you want to save multiple projects, but keeps replace previous project with the same name? May share some screenshots.Best,
PaulYes I have two tables named Project and Accounts with Many-to-Many relationships. So if I create a Project for first time with a account then there is no error but for the second time with same account, the first project is getting replaced with the second one.
This problem got solved when I created a transactional table and linked the two project and account tables with it. Well thanks for the reply!
Warm Regards,
Sowjanya Matadh
