How to create a reference between tables Control Objectives and Citations

[Anh H_]

Hello,

I have imported content into 2 tables in ServiceNow called Control Objectives and Citations. The source data for these tables is in a csv file in case it's relevant. Each row in the Control Objectives table (screenshot 1) corresponds to several rows in the Citations table (screenshot 2). In other words, different citations can share the same control objective. I'm trying to establish a relationship/reference between these 2 tables so that when I click on each name in the Control Objectives table, I can see a list of citations that are associated with the aformentioned name. For example, right now the list of citations for control objective "Acceptable Discoverable Information VPM-06.8" is blank and I want it filled with the associated citations from the Citations table (screenshot 3). Please find below the screenshots. I've searched a lot of places for suggestions, but couldn't find anything that I could easily understand or adapt for my problem. Any help would be greatly appreciated. Thank you so much!  

Screenshot 1
 

Screenshot 2

Screenshot 3

[dmathur09]

Hi Anh,

So you mentioned that you have two different csv file one for citation and other for control objectives. My question to you is if you do not have a relationship in your csv file, how would you expect Servicenow to connect both the files. You would at least first need to map the relationship between Citation and Control Objectives before you upload to the instance. If we first draw a relationship between both the files then we would be easily able to put that data into servicenow.

Regards,

Deepankar Mathur 

[Sebastien Fix1]

You need to populate 3 tables: citations (A) and policy_statement (B) for the content and then, in addition, the m2m for the relationships between A&B.

Even if you were to manually link citations to COs, SN would record a new row in the m2m table for every single relationships. There is no way to work in SN without using m2m tables, even if not specified black on white in the Story you may be working on - it is implied.

[Marriam]

Anh, 

I'm currently in the same predicament. Were you able to establish the relationship between your CO and Citation? I've tried using the same Reference number but so far it hasn't worked. Any input will be much appreciated! TYIA