Hi All,

I'm using Enterprise v6 and I have a form which captures information about suppliers and which department (linked to the Department List) has contracted with the supplier.  This form has a subform for the services that supplier provides, including a field for the dollar value of the service.  I need to check this dollar value against a max value for the department.

So, in summary I need to do is store the maximum value for each department and test against it.  To do this I'd like to extend the functionality tied to the organisation structure. 

1. I tried adding a field to jwdb.dir_deparment but as there is no hash value, is there a way to reference it?
2. If so, is there a way to update the field from within an app?
3. Otherwise, is there a way to create a table of additional information which is linked to jwdb.dir_deparment table?

Regards,

Paul