# Split a single record at table level in two records?

**URL:** <https://www.dynamicsuser.net/t/split-a-single-record-at-table-level-in-two-records/47979>\
**Category:** Developer Forum\
**Created:** [September 4, 2013, 7:26am UTC](https://www.dynamicsuser.net/t/split-a-single-record-at-table-level-in-two-records/47979 "2013-09-04T07:26:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kkiran](https://avatars.discourse-cdn.com/v4/letter/k/e47c2d/32.png) [@kkiran](https://www.dynamicsuser.net/u/kkiran)\
**Post date:** [September 4, 2013, 7:26am UTC](https://www.dynamicsuser.net/t/split-a-single-record-at-table-level-in-two-records/47979/1 "2013-09-04T07:26:47Z")

</div>

Hi All,

I have a table containing 10 fields. let say i have i have one record in it. 5 fields are some input amount fields lets say In1,In2,In3,In4,In5 and similarly i have five output fields like Ou1,Ou2,Ou3,Ou4,Ou5. Now i have a form where i have a grid. which shows all in fields in one line of grip and other Ou fields in second line of same grid. Is it possible ??? to split a single record at table level in two records on form in a grid?

Regards,

Kalpna

_(Subject updated by admin)_

---

<div class="post-metadata">

**Author:** ![vishalsdata](https://avatars.discourse-cdn.com/v4/letter/v/ecc23a/32.png) [@vishalsdata](https://www.dynamicsuser.net/u/vishalsdata)\
**Post date:** [September 4, 2013, 7:33am UTC](https://www.dynamicsuser.net/t/split-a-single-record-at-table-level-in-two-records/47979/2 "2013-09-04T07:33:03Z")

</div>

Did not understand what actually you want to do ?? Basically if you want to get record in two different lines in a grid then better to use two tables and relate it using some primary key. Guess you can easily do it using the way i said.

---

<div class="post-metadata">

**Author:** ![admin1](https://sea1.discourse-cdn.com/flex023/user_avatar/www.dynamicsuser.net/admin1/32/7476_2.png) [@admin1](https://www.dynamicsuser.net/u/admin1)\
**Post date:** [September 4, 2013, 7:33am UTC](https://www.dynamicsuser.net/t/split-a-single-record-at-table-level-in-two-records/47979/3 "2013-09-04T07:33:22Z")

</div>

Hi Kalpna,

As you are not a new member and have already posted 47 posts, then you should have been familiar with our guide lines for posting here on the Dynamics User Group. And one of the very clear messages is that your subject should say something about your actual problem, NOT just “Urgent help needed!”.

Please ready our How to ask a question?