1 Topic by yves.feigneux (edited by yves.feigneux 2021-08-16 12:02:08)

  • Registered: 2021-03-27
  • Posts: 15

Topic: Table grids aren't able to work when you have 3 tables in cascade.

Hello,

I have 3 tables in cascade and it seems that it isn't possible to retrieve the data from the first level.
I have sex -> user -> agenda.
In the tablegrid output of the search, I cannot retrieve the sex of the user.(I have 4 records represented instead of 2).
If someone could look at this simple project and help me to solve the issue.
Many thanks,

Yves

Post's attachments

Attachment icon sex.zip 326.39 kb, 167 downloads since 2021-08-16 

  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 891

Re: Table grids aren't able to work when you have 3 tables in cascade.

For the Sex table (in Database tables), put Check - The table is a dictionary, and try now.

3 Reply by agusecc (edited by agusecc 2021-08-16 15:31:35)

  • Registered: 2015-12-19
  • Posts: 109

Re: Table grids aren't able to work when you have 3 tables in cascade.

Hello,

I have 3 tables in cascade and it seems that it isn't possible to retrieve the data from the first level.
I have sex -> user -> agenda.
In the tablegrid output of the search, I cannot retrieve the sex of the user.(I have 4 records represented instead of 2).
If someone could look at this simple project and help me to solve the issue.
Many thanks,

Yves

I tray fix your project maybe can help you.  you must add calculated field in table user

see attactment

Post's attachments

Attachment icon Yves fixed.rar 294.05 kb, 194 downloads since 2021-08-16 

  • Registered: 2021-03-27
  • Posts: 15

Re: Table grids aren't able to work when you have 3 tables in cascade.

sparrow wrote:

For the Sex table (in Database tables), put Check - The table is a dictionary, and try now.

  • Registered: 2021-03-27
  • Posts: 15

Re: Table grids aren't able to work when you have 3 tables in cascade.

Thanks it is another alternative to check the table as a dictionary.