View that multiplies data from other two tables
S

Hello, I need to creat a doble entry table, or view I supose. I need to multiply the values in colum 5 of the first table times the values in colum 1 of the second table, creating a new colum for each "colum 5 x value in colum 1". And add the other information in the registries of the second table.

Materia Prima

Screen Shot 2019-06-10 at 00.26.29

I add a third table that shos to what I whan to arrive. Sorry they are in spanish.

Objetivo

I would really apreciate some help here. Thanks!

Ninox Profile

Is there a field that is the same value on each table?   Sounds like you need to create a relationship between the tables.. Once the relationship is created, then you can use the value. 

S

They are both child tables of a same parent. There isn´t a fild of the same value on each table, its kind of merging both tables. The first table is a recipie and the second table is how many times you do that recipie denpending on the size of cake you have to make and there for the mold you have to use.

Ninox Profile

Is there an "order" table ?? Or something that indicates you are making a Mucho Grande vs a Grande?  Is that on the parent table?   

S

The structure of the table is:

Inventory

Assembly Productos

- Inventory Items

- Quantity

Molds

Sizes

 

Inventory is where I have de raw materials for the recipy and is related to the childs inventory items and the child table Quantity is related to the Molds and Sizes tables

Reply