Showing info from differnt tables

[hanswittoeck]

Hi,

I cannot get this done  properly

Material			Material type		Sales
Material	Description		Material	Type		date	material	Value
123	BLUE BIKE		123	BIKE		03-Jun	123	500
124	RED BIKE		124	BIKE		05-Jun	124	530
125	GREEN BIKE		125	BIKE		07-Jun	223	1000
223	BLUE CAR		126	BIKE		09-Jun	225	1000
224	RED CAR		223	CAR		11-Jun	126	500
225	GREEN CAR		224	CAR		13-Jun	225	1000
226	BLACK CAR		225	CAR		15-Jun	226	1000
			226	CAR
Report
123	BIKE	BLUE BIKE	500
124	BIKE	RED BIKE	530
126	BIKE		500
223	CAR	BLUE CAR	1000
225	CAR	GREEN CAR	2000
226	CAR	BLACK CAR	1000

intention is that all materials are in the overview. Description is shown when present, otherwise leave blank

Thank you for your help

Hans

[ryan_mayu · Accepted solution]

@hanswittoeck 

here is a workaround for you

pls see the attachment below