Lagerstyring af flasker med differenceret indhold

Klaus, can explain what status/netto beholdning is otherwsie we dont know if its possible or not.

I can see that status is [Netto Kg] - [Brugt kg]

Det kan man godt. Jeg vil kunne give dig et tilbud på at løse opgaven hvis du er interesseret ?

"..Jeg vil kunne give dig et tilbud på at løse opgaven .."! Maybe I missed something, is gerifix28 suggesting he wants to pay for a solution? If so then this question should be in another category, if not then we should wait and see if we can find a solution which is free.

En løsning er at oprette en tabel ved hjælp af forespørgslen og globale variable. Der er et eksempel på dette, som er rimelig simpelt og temmelig tjekket, her:

http://www.blueclaw-db.com/download/running_sum_query.htm

Terry, thank you for your comment - i don´t want to pay for a solution.
imagine this: a bottle with 11 kg (flaskeID)and(netto), a order where there is used 1 kg(brugt kg) gives a (status) of 10 kg. These 10 kg are the (new netto kg).
Now comes the tricky part, a new order on the same bottle, now with a order of 0,5 kg, this should be from (new netto kg). = 9,5 kg.

Hilsen Klaus

Klaus, I think the correct solution all depends on how you design the tables and how you interact with the user.

Lets say you have a table with Bottle types. In this table you would have the details such as weight.

Now I guess that you have many of the same type so you might also have another table which contains info on each bottle (type (from type table), Flakse ID) and any other information which is specific for a unique bottle.

Now you need another table where you register all of the movements which you show in the example in your original question. NOTE I have reomved some of the fields because these come from another table or are calculated.

OrdreID, FlaskeId, [Brugt dato], [Brugt kg]

If you enter the inoformation in a form then you could show the bottle information on the main form and the movements in a sub form. On the main form you would see the [Netto Kg] taken from the Bottle Type table, and I would suggest that in the Bottle table you have a field which reflects the status of the bottle. This field should get updated after each movement.

So you only have one field (in the bottle table) which shows the correct status [Netto Kg]. You could also have it in each movement record.

Depending on which method you want depends on the solution although they are very similar.

I can see how your data looks at the moment but I'm not sure how you enter the data or if its all in one table.

Hope that all makes sence

Terry do you have an email?

ekspertenATsanthell.dk

AT = @

I dont know if you have sent anything but I havent yet received anything

I have sent you an email Terry

After looking at the dB the solution is to update [Netto Kg] each time a new order is made.

In the forms after Insert event


If MsgBox("Update Netto Kg?", vbQuestion + vbYesNo) = vbYes Then

    DoCmd.SetWarnings False
    DoCmd.RunSQL "UPDATE Beholdning SET [Netto Kg] = [Netto Kg] - " & Nz(Me.Brugt_kg, 0) & " WHERE FlaskeID = " & Me.FlaskeId
    DoCmd.SetWarnings True
   
    Me.Beholdning.Form.Requery
   
End If

Tak for hjælpen - jeg er i test mode på den så jeg vender tilbage ved andre...

tak