0

One table with two relacion N:1 is possible generate a query view ?

I send the Demo, I thought I could solve it

5 replies

null
    • Fred
    • 4 days ago
    • Reported - view

    What exactly do you want to in this table?

      • Rafael Sanchis
      • Rafael_Sanchis
      • 4 days ago
      • Reported - view

       hi Fred.

      Need create a View with the info of two field relation field.

      • Fred
      • 4 days ago
      • Reported - view

       please be more descriptive.

      1) which table is the view in?

      2) what fields do you want to show from which relationship?

      I also just thought that you can do what you want with an HTML field since you can create your own JSON data and display it however you want.

      • Rafael Sanchis
      • Rafael_Sanchis
      • 4 days ago
      • Reported - view

       

      In the TblIntegration table I have two relationship fields. I need a view field with all the fields of each relationship field.

      • Fred
      • 4 days ago
      • Reported - view

       Since TblIntegration is the many side of the relationship you can't do a view from the relationship as there is only 1 record. I think an html table with custom data from a JSON would be the way to go here.

Content aside

  • 4 days agoLast active
  • 5Replies
  • 12Views
  • 2 Following