Often, our sales people have a need to enter a new product into the
PRODUCT table while giving a quote. This is due to a slight change in
an already existing product. I have a BIT button places on the detail
line that will bring up the form.
Now what I want to do is have specific fields entered into another table
I have so I will know I have to format the new product. I gave the
MODEL field a component ID of Order_Model. Here is the EEP that IS in
the BIT button
SET VAR vFormMode = 'Enter'
ENTER USING KayParkProduct FOR 1 ROW
PROPERTY Order_Model REFRESHLIST TRUE
GETPROPERTY Order_Model TEXTVALUE vModel
INSERT INTO PRODUCT_NEW VALUES +
(.vOrderID, .vModel, 'N', 'N', 'N', 'N', 'N', 'N', 'N', '-0-')
RETURN
I am able to enter the new item into the PRODUCT table. The OrderID and
all the other values are entered into the PRODUCT_NEW table
EXCEPT the model. The field is blank in the table.
I know this is simple, but your help is appreciated.
Jim
