Forum Discussion

GeorgeFong's avatar
GeorgeFong
Qrew Trainee
12 years ago

How to create a view or maybe report combine the items from 2 tables?

Hi All, I have 2 tables that have some of the same fields: - Sales (invoice #, customer name, grand total and other fields) - Services (invoice #, customer name, grand total and other fields) I...
Formulas and functions
reports and charts
Tables and fields
ArchiveUser's avatar
ArchiveUser
Qrew Captain
11 years ago
Hello dandiebolt,

I've incorporated your "concatenate data" script to successfully retrieve data from three separate child tables and have it combined in one data set.  I can see that the final data set does contain a 2 x n array of data.  My biggest hurdle now is writing the syntax to display this data as an HTML table.  I've searched high and low on how ot do this and need some help.  Would you be able to enlighten me on how to 'convert' the javascript array into an HTML table?