Expresion field 2

[Guest]

Thank you, for the replies.

I will explain in detail: I have delivery note lines each with it's own ID.
The unit that must be counted is cartons. The whole line is not shipped at
once. A line can have 10 cartons that will be shipped in 3 shipments
different
dates ex. I will have one user that records the delivery note and another
that does the shipments, the person who does the shipment must be able to
see how many cartons on a line is avalible to ship.
If the user decides to ship 3 cartons, and he fill in 3 in the shipment
form, when he moves to a new record in the form this must be updated /
calculated so that he can see only 7 are left when he does a next shipment
Tanks for all the help.

 

[Joseph Meehan]

Thank you, for the replies.

I will explain in detail: I have delivery note lines each with it's
own ID. The unit that must be counted is cartons. The whole line is
not shipped at once. A line can have 10 cartons that will be shipped
in 3 shipments different
dates ex. I will have one user that records the delivery note and
another that does the shipments, the person who does the shipment
must be able to see how many cartons on a line is avalible to ship.
If the user decides to ship 3 cartons, and he fill in 3 in the
shipment form, when he moves to a new record in the form this must be
updated / calculated so that he can see only 7 are left when he does
a next shipment Tanks for all the help.

Let's hope I can get the idea across and that I am not repeating
something you already know and are trying.

I suggest a table called shipped. This table will record each shipment
for each delivery. It will have an delivery ID field and a quality field.
It will record all shipments for any delivery. (I am assuming that delivery
is your basic unit, normally it might be called invoice, or sale, etc.)

Now using both tables you can use a form to show a delivery along with
the number of cartons ordered and a list (subform) of shipments and the
number of cartons in each shipment and the net remaining cartons to ship.

If you add things like date shipped, who shipped, how shipped etc to the
shipped table that can also be displayed.

Is that what you want?