Very annoying situation!! fields turn empty when I add a new table

[MrJukas]

Hello,


I have this kind of big file, and it was working great, until I added the last table Quantity.Sales Order SW.

Basically, the other fields On-Hand SW, Purchase Order and Quarantine turn empty!!

If I remove the Sales Order SW table, the number come back as they should.

Anyone know why this is the case??!?!


thanks

[Neil Bingham]

Possibly to do with criteria set in the join properties to Inventory Projection (double click the link to see and try changing)- or your data in the two tables doe not match

[CJ_London]

min and max are reserved words - that may be causing the problem

Also, not sure you are showing the whole query - are there criteria being used? If so, what?

[MrJukas]

Super Weird!!

I cancelled the query Sales Order SW and I did again from scratch, and now it works... I guess there was something wrong when I built it the first time... super weird.

thank you guys