• Registered: 2014-09-06
  • Posts: 805

Topic: Grid Colum

I have two tables (person, work) and a table with the phone number.
In the TableGrid Phones which has all the numbers from the two tables (person,work) how is it possible to get the columns in the left side?
See the attached picture  https://i.imgur.com/eRc5HBi.png
II also attached my small software.

Post's attachments

Attachment icon telegrid.zip 336.28 kb, 331 downloads since 2018-02-16 

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

Re: Grid Colum

Hi v_pozidis,
You could probably use calculated fields;  please see attached.
However, if it were me, I would structure my data in a different way;  for example, use just one table for 'person' and 'work' and use a flag ('p' or 'w') to indicate which the row was.  Then you can simply filter the grid by 'flag' to show 'persons' or 'work' rather than needing to create separate forms.
Regards,
Derek.

Post's attachments

Attachment icon telegrid.zip 338.79 kb, 355 downloads since 2018-02-16 

  • Registered: 2014-09-06
  • Posts: 805

Re: Grid Colum

Yes,
Thank you.


derek wrote:

Hi v_pozidis,
You could probably use calculated fields;  please see attached.
However, if it were me, I would structure my data in a different way;  for example, use just one table for 'person' and 'work' and use a flag ('p' or 'w') to indicate which the row was.  Then you can simply filter the grid by 'flag' to show 'persons' or 'work' rather than needing to create separate forms.
Regards,
Derek.