• Registered: 2016-07-28
  • Posts: 1,038

Topic: tGrid field display

Derek has been very kind helping me on similar matter in another thread by sharing Refunds sample project.


This one is similar but not same in respect of functionality and approach.


Issues I have are:
1 Getting crRef and dbRef fields displayed under ref (*) columns of PI and SI tGrids.
2. Selected PI or SI tGrids row is not displayed on PIR or SIR tGrids. I thought this one could be done with a search button but didn't work.


Please see the attached sample project below:

Post's attachments

Attachment icon tGrid Field Display 5 One Table.zip 21.72 kb, 363 downloads since 2017-07-23 

Adam
God... please help me become the person my dog thinks I am.
  • Registered: 2015-11-13
  • Posts: 652

Re: tGrid field display

Adam, See revised.

Post's attachments

Attachment icon tGrid Field Display 5 One Table Revised.zip 599.92 kb, 435 downloads since 2017-07-24 

  • Registered: 2016-07-28
  • Posts: 1,038

Re: tGrid field display

Hi EHW,


I'm glad to see you around...
Your kind help is truly appreciated, as always.............


Somehow it doesn't clear ref (*) columns on PI and SI after deleting refund/s belonging to Invs...
DBupdate after relevant delete/s script there but it doesn't clear.

Adam
God... please help me become the person my dog thinks I am.
  • Registered: 2015-11-13
  • Posts: 652

Re: tGrid field display

Fixed.

Post's attachments

Attachment icon tGrid Field Display 5 One Table Fixed.zip 600.23 kb, 408 downloads since 2017-07-25 

  • Registered: 2016-07-28
  • Posts: 1,038

Re: tGrid field display

Thanks a lot EHW.......................


Some invoices can have multiple refunds. It needs to clear ref column when all refunds relating to inv are deleted.
I tried something with if statement just above your clear code but couldn't get syntax right.

Adam
God... please help me become the person my dog thinks I am.
  • Registered: 2015-11-13
  • Posts: 652

Re: tGrid field display

Here you go.

Post's attachments

Attachment icon tGrid Field Display 5 One Table Revised 2.zip 600.44 kb, 436 downloads since 2017-07-25 

  • Registered: 2016-07-28
  • Posts: 1,038

Re: tGrid field display

Hi EHW,


Thank you very much.....................
Truly appreciated..............................

Adam
God... please help me become the person my dog thinks I am.