Add cascading data from a column in Access with Status by Row

Asked

Viewed 95 times

1

I need to create a control of purchases per line where generates a purchase need considering the quantity of each product per customer compared to stock availability.

As in the example of the table below I have an item XXX that repeats in different customers with different quantities my stock is 10un and the total demand is 21un for the first line I have availability not being necessary to buy however for the second line need to buy 01un, STK-Customer demand A, in the third line I need 10un, STK-Customer demand A-Customer demand B.

It is possible to create this type of control?

Note work in a company that has registered 15mil products where we receive orders every day.

Example table Attachment: inserir a descrição da imagem aqui

Result table Attachment: inserir a descrição da imagem aqui

I’m trying to adapt this Cód. I found on this site of Mr Alegr in the theme Add cascading data from a column in Access, but as it sums up by date and the BD where I am working the same item repeats at least 15 clients in the same day I’m not getting.

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.