Partial Delivery based on Order

[andria]

Hello.

I created a fast form called Request from Customer. Inside the table contains (req_id, req_product, req_quantity, req_paiement). Each request contains only 1 product for delivery. Delivery are: Full (One time) or Partial like If I received an order for 1000 quatities for delivery. But the delivery is partial: 500 first time, 250 second time and 250 the final delivery.
Should I create a subform to manage this partial delivery? And how to print each delivery? And I cannot create new delivery if I attempts 1000 quantities

Thanks for advising me.

Regards

Andria

PS: New to NuBuilder and trying to work on this best open source web database apps

[kev1n]

Hi,

It's probably best to use a Subform to manage these partial deliveries.

And I cannot create new delivery if I attempts 1000 quantities

Can you explain in more detail what you mean or what doesn't work.?

[andria]

Hi,

And I cannot create new delivery if I get 1000 quantities

Can you explain in more detail what you mean or what doesn't work.?

Based on the quantity requested by the customer. Ex: 1000 units (it will be on request form). So if i proceed partial delivery: 500 first, 250 second and 250 third on the subform, the requested quantites are reached. So I'd like to stop adding record on the subform.

Regards

A

[kev1n]

To limit the number of rows in a Subform, add an beforeinsertrow event to it.
Use a calc field on the main form to calculate the sum of quantities.

[andria]

Thanks for your help. It's work fine.
I appreciate.