1 Topic by thezimguy (edited by thezimguy 2020-08-07 15:45:43)

  • Registered: 2018-07-19
  • Posts: 260

Topic: [SOLVED] Multi relationship field

Hello guys,
How do I work around this
I have a database with two tables
Users and duty
The user table has columns:
Full name
id_duty1
id_duty2

id_duty1 and id_duty2 are relationships from table duty
How do I produce data in the tableGrid shown in the attached picture
Thanks

Post's attachments

Attachment icon Untitled.png 43.75 kb, 93 downloads since 2020-08-07 

@thezimguy

thezimguy's Website

2 Reply by derek (edited by derek 2020-08-07 13:00:42)

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

Re: [SOLVED] Multi relationship field

Hi,
MVD automatically retrieves the description from the duty table if the table is related to the user table.
However, if you have a second (or third etc) relationship between the same tables, you need to retrieve the second (or third etc) descriptions yourself;  this is most easily done using a calculated field.
Please have a look at the attached for a way to do this.
Derek.

Post's attachments

Attachment icon thezimguy.zip 336.61 kb, 267 downloads since 2020-08-07 

  • Registered: 2018-07-19
  • Posts: 260

Re: [SOLVED] Multi relationship field

Thank you Derek
It solved it

@thezimguy

thezimguy's Website