Split a single record at table level in two records?

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?



(Subject updated by admin)

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.

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?