Forum Discussion

Helper I

8 years ago

Solved

Multiple relations

hi guys!! I have many tables with following relations:

I am doing this table:

I'm not able to obtain the correct result, I don't understand how to work with the inactive and active relationship.

help me, please

BLM
8 years ago
Thanks so much, If it Work i ‘ll tell you

6 Replies

Anonymous
Not applicable
8 years ago
I'm not exactly sure what you are asking, but I guess we can start with what IS the intended result? Are their not supposed to be blank values? Are the rows and columns correct? Are you looking for a calculation?
- BLM
  Helper I
  8 years ago
  I would like obtain a matrix like photo.
  Rows: Productos[prodcode]
  Columns: calendar[fecha]
  Values: sum off ‘cantidad from detcargas and ‘cantidad from ops.
  The relations are in the image attached
  - BLM
    Helper I
    8 years ago
    I want obtain a matrix with dates from several tables.
    "detcargas" contain the quantity of product that has been load in a determinate date.
    "ops" contain the quantity of product that has been produced in a determinate date.
    "Product" it's the table that contain all products of a factory, and "Calendar" is a calendar :)
    The relations are:
    productos[prodcodigo] with ops[op_producto_codigo]
    productos[prodcodigo] with detcargas[dcarproducto]
    calendar[fecha] with detcargas[dcarfecha_cam]
    calendar[fecha] with ops[op_fecha_planificada]
    my goal it's obtain a matrix that show the evolution the stock per day, for it, i need a matrix which rows will be all products from "table products", the columns will be a date range from "calendar table" and the values will be an acumulate sum from quantityes of products produced (ops) minus quantityes of product loaded (detcarga)
    
    thank