I created the below EEP on field exit (field MODEL#) so new items get
inserted into a special table so I can format the product later. This is
used for quoting purposes. We sometimes have custom quotes on existing
items that get "tweaked" a little for the customer.
Insert into PRODUCT_NEW select CONTROL#,MODEL +
from ORDERDETAIL where +
MODEL# not in (select MODEL# from PRODUCT)
RETURN
The EEP does insert new items into the new table but the problem is I
want to be able to also make sure the new items are not already in the
PRODUCT_NEW table in case I have not been able to format the items
before the next entry.
I tried that with: MODEL# not in (select MODEL# from PRODUCT_NEW).
I got an error message stating I could not have the destination table as
part of the FROM clause.
Any suggestions would be appreciated.
Jim
