SubForm OrderDetails Limitation

[francogaspari]

Hi Dear All.
how can i make a limit to my OrderDetails Subform , to generate just only two order details in each order?
example:



Mr. Bla bla Bla

OrderDetails Subform:

- Milk - qty 9 - Price: 12$
-Chocolat - qty 10 - Price: 10$

and stop here.... i don't want to have the ability to asking for more .

Thanks.

[burrina]

You could use this code to limit the record count to 2 records. Use the Before Insert Event.

If Form.RecordsetClone.RecordCount > 2 Then
Cancel = True
End If

HTH

[orange]

That seems a strange and restrictive request (business rule). If a Customer makes an Order and that Order includes 5 distinct items, then why would you restrict an Order to only 2 Items? If this is academic then fine, but in the real world such a constraint could/would cost you some business (in my view).

See free data model here for ideas.
Good luck with your project.

[francogaspari]

thank you Burrina, i will try it now
and
Orange in the program i am making , in each order i make , i just sell TWO products only not more, but maybe can be ONE but sure not THREE for zat.

[orange]

And you never plan to add another product or two to your products list- ever?
Ok as I said strange and restrictive, but in your case it seems appropriate.

Good luck.

[francogaspari]

Dear Mr. Orange
i sell Insurance Car Policies, in each "order" i make, there is one client , and just two policies not more. One for Motor Damage and Another One for Motor Bodily Injury and in some cases client ask for just the first one

[orange]

Perfect for your current business. I was just thinking that it would be restrictive if you decided to sell Life Insurance or Boat Insurance etc.

[francogaspari]

No Orange it will never works with my forms, coz the form for Motor insurance order is completely different in DATA,than the life and workers, as you can see an example for the car order sheet>>>> Below