bgarside. Thank you for your reply.
Yes I tried this and it works pretty well until you want to show just the capacity for a ressource at a specific date in a chart.
This happens because the Date-table is connected via %FAUF-Vorgang with PRODORDERS. There you find %RES-ID.
But the relation between PRODORDERS.%RES-ID and CAPACITY.RES-ID is 1 - N. The result is that you get many ressources for this %RES-ID for many dates. When you use CAPACITY.Date as seperate listbox item this is no problem. Perhaps there is some set expression magic to solve this problem?!
- PS -