Hi @Ramu8 ,
To establish a relationship between the User and Project tables in ServiceNow similar to the skill relationship, you can create a reference field in the Project table that refers to the User table. Additionally, you can create a related list on the User table to display associated projects.
1. **Create Reference Field in Project Table:**
- Go to the Project table in ServiceNow.
- Create a new field, let's call it `user_ref`, of type Reference.
- Set the reference table to the User table.
2. **Create a Related List in User Table:**
- Go to the User table in ServiceNow.
- Create a new related list, let's call it `projects`.
- Configure the related list to display records from the Project table where the `user_ref` field matches the user.
3. **Establishing Many-to-Many Relationship:**
- If you need a many-to-many relationship, you may consider creating a separate table (e.g., `user_project_mapping`) with reference fields to both User and Project tables.
4. **Populate User Skills Table:**
- If you want to store additional information about the relationship (similar to `sys_user_has_skill`), you can create a new table (e.g., `user_project_mapping`) to store these records.
Keep in mind that "out of the box" (OOB) configurations might vary, so adjust these steps based on your specific ServiceNow instance and version. Additionally, consider testing the changes in a non-production environment before implementing them in your live instance.
Thanks,
Danish
