Karen,
Since I have people who have a tendency to skip over fields, (use mouse
clicks instead of Key through the fields), Could I have the IF THEN
statement in the model field as such:
--GETPROPERTY Order_Model TEXTVALUE 'vModel'
--SET VAR vSortone = Sortone IN Product WHERE Model# = .vModel
--SET VAR vKPRList = KPRSell IN Product WHERE Model# = .vModel
--SET VAR vTankSorts = 'TA,TB,TC'
--SET VAR vSortcheck = ('('+.vTankSorts+')')
--IF vSortone IN &vSortcheck THEN
--PROPERTY Comp_ListPrice READONLY 'FALSE'
--RETURN
Jim
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of
[email protected]
Sent: Wednesday, December 23, 2009 11:25 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: edit field
On exit from the model# field you should look up the list price. Use a
Property Textvalue to put the list price in the KPRSell DBEdit field.
The default property for KPRSell would be read-only true (or you can use
"enabled" but it has a tendency to lighten the value and some have
problems reading it).
On exit from the Sortone field, if the value is TA,TB, or TC, then
change the Property Comp_ListPrice read-only 'false'. Otherwise you can
set focus on another field.
Seems easy to do unless I'm misreading what you want...
Karen
In our Order entry form, under most circumstances I do not want the
entry people to be able to change the list price for items sold.
There is however one case where it would be good for them to change the
list price.
When we sell one product the list varies based on the additions to the
product. We do not want to have line items for those items because the
product is essentially the same with added gauges, etc.
The field that determines the lookup for the list price is Model#
(componentID Order_Model).
The field that would allow changing of the list price is called Sortone.
If this one is TA or TB or TC I would allow list price change.
The field that would be changed is KPRSell (ComponentID Comp_ListPrice).
I was thinking of using an On exit EEP in the Model# field
Jim
