1 Topic by Step-in (edited by Step-in 2023-12-11 14:51:46)

  • Registered: 2023-08-17
  • Posts: 32

Topic: [Solved] Why is data retrieval from the subtable incorrect?

I have TableGrid1 and selection from the database PayeeRegister, Street, StreetCat. When the data is displayed in TableGrid1, it is duplicated according to the records in StreetCat, but I have only one value filled in the table PayeeRegister and Street.

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

Re: [Solved] Why is data retrieval from the subtable incorrect?

It is easier to understand your problem if you can attach your project (delete the .exe file and then zip the project folder).
Derek.

3 Reply by Step-in (edited by Step-in 2023-08-22 12:31:21)

  • Registered: 2023-08-17
  • Posts: 32

Re: [Solved] Why is data retrieval from the subtable incorrect?

This is an illustrative example. The same problem arises when generating a report. When adding a StreetCat, the number of fields in the tablegrid1 increases, but there is actually only one field in the main table PaymentsRegister.

Post's attachments

Attachment icon PaymentsRegister.zip 335.72 kb, 77 downloads since 2023-08-22 

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

Re: [Solved] Why is data retrieval from the subtable incorrect?

Hi,
Thanks for the example;  it makes it much easier to see what's going on.
In your data schema, remove the check-mark from the 'is dictionary' check-box (street table)and try it again (see attached).
Derek.

Post's attachments

Attachment icon screenshot.jpg 73.84 kb, 24 downloads since 2023-08-22 

  • Registered: 2023-08-17
  • Posts: 32

Re: [Solved] Why is data retrieval from the subtable incorrect?

Thank you very much for your help.