0
tables:

T_THERA - is a transaction table
    Columns: ID - STRING
             MR - STRING
             ITEMCODE - STRING
             QTY - INT
             SIGNA - TEXT
M_ITEMS - Masterfile of items
    Columns: ITEMCODE - STRING
             DESCRIPTION - STRING
M_SIGNA - Masterfile of Signa
    Columns: SIGNACODE - String
             DESCRIPTION - String

I have a DGV1 with retrieved data...

sql of DGV1 is something like "SELECT T.ID, M.DESCRPTION, T.QTY, T.SIGNA
                               FROM T_THERA T, M_ITEM M WHERE T.ITEMCODE = M.ITEMCODE AND 
                               T.MR = '"& AS_MR &"'"

I need to change the SIGNA column to a combobox. BUT the data in the combobox is a masterfile from another table (M_SIGNA).  The DGV1 is populated from another window with a selection of items (M_ITEMS).  If new items are inserted, the SIGNA (now a combobox) on T_THERA should be null and user can select the correct value from the populated combobox (M_SIGNA).

The user then should be able to save the transactions.

I have been looking for a better solution but to no avail.  I'm just losing hope on this!  Please share your ideas on how to go about my problem.

Thanks!
2
Contributors
1
Reply
13
Views
3 Years
Discussion Span
Last Post by PerplexedB
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.