# Help with "Parent Columns and Child Columns don't have type-matching columns." **URL:** \ **Category:** Epicor ERP 10\ **Created:** [October 5, 2017, 3:35pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717 "2017-10-05T15:35:27Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![shobdy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/4491bb/32.png) [@shobdy](https://www.epiusers.help/u/shobdy)\ **Post date:** [October 5, 2017, 3:35pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/1 "2017-10-05T15:35:27Z")
Hello, I am trying to link PORel table to TranGLC table and I am getting the “Parent Columns and Child Columns don’t have type-matching columns.” error. I understand that the column type must match but before I go through some effort to set up a bpm to copy the wanted column from TranGLC to a UD column on PORel, I was wondering if there was an easier/better way of doing it? My goal is to print the GL code on each line of the PO Report. All input is appreciated. Thanks, Shawn ---
**Author:** ![shobdy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/4491bb/32.png) [@shobdy](https://www.epiusers.help/u/shobdy)\ **Post date:** [October 5, 2017, 7:39pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/2 "2017-10-05T19:39:34Z")
Any ideas? Anybody?? ---
**Author:** ![bmgarver](https://www.epiusers.help/user_avatar/www.epiusers.help/bmgarver/32/2867_2.png) [@bmgarver](https://www.epiusers.help/u/bmgarver)\ **Post date:** [October 5, 2017, 7:49pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/3 "2017-10-05T19:49:52Z")
![image](https://epiusers.help/uploads/default/original/2X/3/3554b24dd04bc51e77c2565fb22bfeaf725fd22d.png) ---
**Author:** ![shobdy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/4491bb/32.png) [@shobdy](https://www.epiusers.help/u/shobdy)\ **Post date:** [October 5, 2017, 8:04pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/4 "2017-10-05T20:04:38Z")
@bmgarver That does technically fit the question because I was vague. What I need to to link the two tables in RDD so I can use the GLAccount field on the SSRS report when printing the Purchase Order. I tried what you showed on the Relationships tab in RDD and it didn’t take it. Any ideas on how to do it in RDD or writing a BPM that copies the TranGLC.GLAccount field to a UD @ PORel.GLAccount\_c? Or a third way that is easier/better? ---
**Author:** ![shobdy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/4491bb/32.png) [@shobdy](https://www.epiusers.help/u/shobdy)\ **Post date:** [October 6, 2017, 7:55pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/5 "2017-10-06T19:55:13Z")
Anybody have any ideas? All help is appreciated. Thanks, Shawn ---
**Author:** ![josecgomez](https://www.epiusers.help/user_avatar/www.epiusers.help/josecgomez/32/55731_2.png) [@josecgomez](https://www.epiusers.help/u/josecgomez)\ **Post date:** [October 6, 2017, 11:12pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/6 "2017-10-06T23:12:08Z")
You can’t do it in RDD bpm is the only way I know. 😖 ---
**Author:** ![frontierits](https://www.epiusers.help/letter_avatar_proxy/v4/letter/f/96bed5/32.png) [@frontierits](https://www.epiusers.help/u/frontierits)\ **Post date:** [October 7, 2017, 1:53pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/7 "2017-10-07T13:53:39Z")
You would also need to include The RelatedToFile field in your join to limit the records to those where the RelatedToFile =‘PORel’ I have not tried this in an RDD, but the join relationship between TranGLC and PORel in the straight SQL Syntax is something like this: select top 10 POR.PONum, POR.POLine,POR.PORelNum,TGL.GLAccount from erp.tranglc TGL with (nolock) inner join ERP.PORel POR with (nolock) on (TGL.Company = POR.Company and TGL.Key1 = POR.PONum and TGL.Key2 = POR.POLine and TGL.Key3 = POR.PORelNum and TGL.RelatedToFile=‘PORel’) ---
**Author:** ![shobdy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/4491bb/32.png) [@shobdy](https://www.epiusers.help/u/shobdy)\ **Post date:** [October 9, 2017, 1:07pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/8 "2017-10-09T13:07:15Z")
Hello @frontierits, That was the join I attempted but didn’t work. The key fields are strings and the PONum, POLine, and PORelNum are integers. After I tried a couple of different things with that, I figured that wasn’t going to be my answer. But I asked anyways in case I was wrong. Hey @josecgomez , I figured it was going to be a BPM but I haven’t wrote one like this quite yet. Any pointers on writing a BPM from the PORel side that would trigger a copy of the GLAccount when PORel gets loaded? That would be ideal. If not, how about when PORel is updated. I appreciate anyone on this forum’s helps ides, etc… Thanks, Shawn ---
**Author:** ![knash](https://www.epiusers.help/user_avatar/www.epiusers.help/knash/32/74179_2.png) [@knash](https://www.epiusers.help/u/knash)\ **Post date:** [October 10, 2017, 10:31pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/9 "2017-10-10T22:31:37Z")
If this is related to your other post. Think you can do this in the RDD. Please post your expression. This might help. The string value needs to be in a cast statement. Select \* from Erp.TranGLC glc inner join PORel po on glc.Key1 = cast(po.PONum as varchar) and glc.Key2 = cast(po.POLine as varchar) and glc.Key3 = cast(po.PORelNum as varchar) and glc.RelatedToFile = ‘PORel’ ---
**Author:** ![shobdy](https://www.epiusers.help/letter_avatar_proxy/v4/letter/s/4491bb/32.png) [@shobdy](https://www.epiusers.help/u/shobdy)\ **Post date:** [October 17, 2017, 4:33pm UTC](https://www.epiusers.help/t/help-with-parent-columns-and-child-columns-dont-have-type-matching-columns/40717/10 "2017-10-17T16:33:44Z")
Hello all, There was not a good answer to this and I got a different way of doing what I wanted from another post. [https://epiusers.help/t/how-do-you-copy-an-integer-field-to-a-ud-string-field-in-the-same-table/40792](https://epiusers.help/t/how-do-you-copy-an-integer-field-to-a-ud-string-field-in-the-same-table/40792) I am going to mark this as answered. Thanks all of you for your help and input. Shawn