evidenta

Question

buna seara

am o baze de date structurata astfel

1 - nume si fisa

2 - categorie

3 - locatie

4 - stoc

relatii 1-4 one to many 2-4 one to many 3-4 one to many

5 - operatiune

6 - tip operatie

relatie 4-5 one to many 6-5 one to one

in tabelul am valoarea stoc sau stoc actual care trebuie sa se actualizeze in functie de ce operatie se face, la fiecare modificare a tabelului operatie

am reusit in tabelul operatie sa se actualizeze doua valori adauga si scadere

dar nu reusesc sa gasesc sa actualizez stoc sau stoc actual cu noile valori ( stoc si stoc actual sunt in tabelul stoc, adauga si scadere in operatie)

Answer 1

Once more and I'm done.

SOLD ACTUAL = SOLD + ADAUGA - SCADE

You do not need to store the result of the calculation, SOLD ACTUAL, in the table.

You can display the calculated result, that is, SOLD ACTUAL, in a query, on a form, or in a report.

This principle is a fundamental of good relational database design.

I assume that SCADE, which Google Translates as "Expires" means the loss of inventory due to expiration.

In any event, if you want to adjust your inventory to account for SCADE add an additional record for that, don't risk data integrity by storing the calculated value.

Answer 2

FIECARE OPERATIUNE AM TRECUTO SEPARAT

O OPERATIUNE DACA ADAUGI REZULTA CA LA ADAUGA E CANTITATEA CARE O INTRODUC SI LA SCADERE E 0,

IAR LA SCADERE INVERS

SOLD ACTUAL = SOLD + ADAUGA - SCADE

Answer 3

If you want to add additional changes to inventory (such as decreases due to breakage or shrinkage) those decreases should be entered as additional transactions, not modifications to calculated and stored values.

Answer 4

am inteles doar ca am nevoie asa, deoarece vreau sa adaug la tsoc ceva dupa aceea sa scad, iar stocul se actualizeza, am studiat si am observat ca nu stocheaza in tabel variabila stoc

Answer 5

Typically, we do not store calculated values in a relational database application.

For a working demonstration of how to manage inventory, please download and study the Northwind Developers Edition Template: https://support.microsoft.com/ro-ro/topic/%C8%99abloane-de-acces-recomandate-e14f25e4-78b6-41de-8278-1afcfc91a9cb