1 Topic by bdcvc (edited by bdcvc 2014-06-12 17:28:59)

  • bdcvc
  • New member
  • Offline
  • Registered: 2014-06-12
  • Posts: 1

Topic: No data after adding a Relationship

Very nice application !! Thanks so far.
I have a table with multiple relationships. Everything works fine.
When I add an relationship in another table, the data referring
to that relationship is not shown in the grid.

Table_A
Random field name
id_Table_B
id_Table_C
id_Table_D

Table_B
Random field name

Table_C
Random field name

Table_D
Random field name
id_Table_E

Table_E
Random field name

Any idea what is going wrong ??

Thanks.

  • Registered: 2014-02-14
  • Posts: 10,294

Re: No data after adding a Relationship

Hello,


Please, send me your project to support@drive-software.com.


Thanks.

Dmitry.
  • Registered: 2017-12-21
  • Posts: 18

Re: No data after adding a Relationship

I have a similar problem.  I have a single relationship in a combo box on my form.  I also have that relationship in my grid.  The text from the relationship does not appear in the grid, only a single digit number,  like and ID number.  How can I get the text into the grid.

Lectrond

4 Reply by derek (edited by derek 2018-01-22 22:13:45)

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

Re: No data after adding a Relationship

Hi,
If I understand your question correctly, a single relationship between two tables will automatically retrieve any relevant text.  Subsequent relationships between the same two tables will only retrieve the record id and not the relevant text.  To retrieve the relevant text for these, the easiest solution is to use calculated fields.
If you can attach your project, someone will be able to show you how to do it or take a look at the attachment (specifically, the 2 calculated fields that are used to retrieve the text from the related table).
Derek.

Post's attachments

Attachment icon lectrondmulti.zip 337.32 kb, 357 downloads since 2018-01-22