I need advice on the following topic, see table descriptions below.
The idea is to be able to select a date (from the mastercalendar) and an article, so that te application shows the corresponding costprice and numbers in stock.
In the COSTPRICE table the date is defined as a range. The STOCK table however contains only the mutation-dates, with the number_in_stock being the actual number.
Because the tables COSTPRICES and STOCKS both contain the column ART_ID, I got a circular reference in my datamodel.
In the end, I would like to be able to do an ABC analysis based on costprice and number_in_stock.
