1 Topic by VascoMorais (edited by VascoMorais 2017-10-25 00:38:14)

  • Registered: 2015-12-25
  • Posts: 211

Topic: Probably a simple dumb question about tablegrids

hey guys, i have a form, that has a "from and to" , it's a simple comunication between us tecnicians.
The thing is that both dbitemid's for both combo box goes to a single sql table name , called tecnicians.

if i guild a tablegrid diag i can only show the first "from" name , is there a way i can use the message.id_tecnicos and message.id_tecnicos1 to display the real names on the tablegrid?

Here's the screenshot to my problem:

https://imgur.com/a/4QRgz

if i use the "name table" i get the first name only
if i use the id table for the whiteboard i get numbers....

  • Registered: 2015-11-13
  • Posts: 652

Re: Probably a simple dumb question about tablegrids

You should setup calculated fields in your main table for the names. Something like the following:

(select name from tecnicos where tecnicos.id = message.id_tecnicos)

(select name from tecnicos where tecnicos.id = message.id_tecnicos1)

You can then place these calculated fields in your tablegrid settings.

  • Registered: 2015-12-25
  • Posts: 211

Re: Probably a simple dumb question about tablegrids

i allways forget about calculated fields...
Thanks!

  • Registered: 2015-12-25
  • Posts: 211

Re: Probably a simple dumb question about tablegrids

hey  do you think that i can use calculated fields to join info from a table into a table search?

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,674

Re: Probably a simple dumb question about tablegrids

Hi Vasco,
Is this the sort of thing that you want? (please see attached).
It uses a calculated field to join 3 fields (first name, last name, town) together so that the calculated field can be used as the search field to find rows of data in the table that match on any of the fields.
Regards,
Derek.

Post's attachments

Attachment icon vasco concatenated calculated search.zip 336.72 kb, 435 downloads since 2017-10-27 

  • Registered: 2015-12-25
  • Posts: 211

Re: Probably a simple dumb question about tablegrids

ahah Derek, very nice, i had done the same result but with a scrip that every time i press the key it will click on the search button.

What i mean is that i want to look up other tables inside a table...
maybe it's not possible