Member Avatar for lordcar 
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
  • 274 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by PerplexedB
Member Avatar for PerplexedB

What is it that makes you think your approach can be improved?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.