Is it possible to UNION two tables in Generic Inquiry?

Hi @MPushpakumara48 

You can use Cross 2 DACs in Generic Inquiry but it will create many duplicate lines of data.

Another way you can create a new DAC is by creating a View in SQL and Union 2 tables in SQL.

Best Regards,

NNT

Thank You!

I use an attribute called MYPIVOT that is a combo, and I add values 1 to 10 as values with sort orders.

Then I use that in my joins.  Add CSAttributeDetail to your inquiry.

The one link to the main table of data has a join of attributeID = ‘MYPIVOT’ and SortOrder is greater than or equal to  2 so it creates 2 lines per main table data row.

Then u join the sub table of data to main but in your join u set the CSAttribututeDetail.sortorder=1. 

The second sub table has a join where the sort order =2

And in your inquiry fields you can do formula’s if you only want data on the first row for instance like

=Iif(/CSAttributeDetail.SortOrder]=1,rARTran.Qty],0)