AnsweredAssumed Answered

Duplicate records in Excel Export

Question asked by andyk3005 on Jan 8, 2018
Latest reply on Jan 10, 2018 by andyk3005

I have a Jobs table and a parts table containing parts used in each job.  I require a valuation display showing all parts not invoiced.   I  execute a find on the jobs table using appropriate criteria and take a summary list of the found set job ID's copy to a text global and relate this to the Parts table.  The find is executed from a pop up window so that I don't have any parent records in the Excel file.   I use "Export to Excel" to build the path and column order.  So far so good.  However the Excel file has the full export twice, one copy and then a second copy.   Further where more than one part  occurs for a job the details of the job are blank.  If any one can shed light on this I would appreciate it.

Outcomes