# Linking 2 tables **URL:** \ **Category:** General\ **Created:** [August 3, 2021, 4:45am UTC](https://community.tulip.co/t/linking-2-tables/3303 "2021-08-03T04:45:55Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![jeevan\_raj](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jeevan\_raj](https://community.tulip.co/u/jeevan_raj)\ **Post date:** [August 3, 2021, 4:45am UTC](https://community.tulip.co/t/linking-2-tables/3303/1 "2021-08-03T04:45:55Z")
Hello, I am trying to establish a link between 2 tables wherein one record from table 1 should be split in to multiple records in table 2 with same ID. Say for example, we have record ID as 1 and columns A, B, C, D, E in table 1 and column C has 3 values separated by a comma, I want these 3 records be split and populated as 3 individual records in table 2. ID column in table 2 is unique however. So, I will create a column named Req. ID as below. Basically there should be a relation between ID column from table 1 and Req. ID in table 2. Table 1: ID A B C D E 1 John, Mary, Chris 2 3 Table 2: ID Req. ID A 1 1 John 2 1 Mary 3 1 Chris Kindly help me how to achieve this. Thanks! ---
**Author:** ![gio](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tulip.co/gio/32/82_2.png) [@gio](https://community.tulip.co/u/gio)\ **Post date:** [August 3, 2021, 3:00pm UTC](https://community.tulip.co/t/linking-2-tables/3303/2 "2021-08-03T15:00:28Z")
hey @jeevan_raj, welcome to the Tulip Community, it would be great if you could introduce yourself at: [Welcome to the Community, let’s meet!](https://community.tulip.co/t/welcome-to-the-community-lets-meet/738)! just to confirm, have you taken a look at using Linked Records in Tables?? [Linking Table Records | Tulip Help Center - Support for Building Operations Apps](https://support.tulip.co/en/articles/4610305-linking-table-records). based on what I’m understanding, this may help simplify what you’re trying to do. but if you do indeed need 2 separate Tables, you could use **Split String** which will create an Array that you can use for the creation of the additional Table Records: ![Screen Shot 6](https://us1.discourse-cdn.com/flex020/uploads/agilemfg/original/2X/d/d99b216b64724ebc06980fa2f98784b9a07a3b10.jpeg) let us know if you have further questions on these suggestions!!