Lock down some fields

[eagle]

1. In the Northwind demo I create a new order.

2. I then click "Order items" to add items to this new order

Please consider the following questions:

A) Is is possible to "lock" the order ID field?

When adding order items it is now possible to select other order ids. Can this be locked down, so that I can only add items to the order in #1 above?

B) Also, could we see the order details ( customer name etc ) on screen when adding order items?

Thanks for all help.

[a.gneady]

You can set the order ID field as read-only in order details. That would effectively lock it.

To show the customer name in order details, you could add a lookup field in the order details table, with parent table set to orders, parent caption field set to customer name, and 'Auto fill' checked. You can add other customer info in the same way.

[eagle]

Hi Ahmad,

Thanks for answering.

>You can set the order ID field as read-only in order details. That would effectively lock it.

I tried that, but then the field does not save. When adding a new item the order ID shows correct as read only field, but in database it is stored as NULL?

[a.gneady]

This issue was fixed in AppGini 5.50, released today

[eagle]

Thanks, Ahmad.

That worked much better