Hello every one,
I asked a question earlier and now I'm refining it to make it clearer (Because I'm now getting to understand my problem).
I have a table "Products" and an attribute "Quantity". I also have a subform in the Invoice from and the subform is created using a query "Invoice_line_q uiry". There is in this query "Invoice_line_q uiry" an attribute "Quantity" taken from the bridge entity "Invoice_Li ne" between the tables "Products" & "Invoice".
My problem is that I don't know how to write in SQL a code that subtratcts the sold quantity in the subform from the qauntity in the table "Products".
Note: My knowledge in SQL is pretty basic but I understand the code in general, it is the directory of each attribute in a query or a table is the thing that troubles me.
Thank's again for all the help.
Paolo.
I asked a question earlier and now I'm refining it to make it clearer (Because I'm now getting to understand my problem).
I have a table "Products" and an attribute "Quantity". I also have a subform in the Invoice from and the subform is created using a query "Invoice_line_q uiry". There is in this query "Invoice_line_q uiry" an attribute "Quantity" taken from the bridge entity "Invoice_Li ne" between the tables "Products" & "Invoice".
My problem is that I don't know how to write in SQL a code that subtratcts the sold quantity in the subform from the qauntity in the table "Products".
Note: My knowledge in SQL is pretty basic but I understand the code in general, it is the directory of each attribute in a query or a table is the thing that troubles me.
Thank's again for all the help.
Paolo.