Forum Discussion

wperkinson's avatar
wperkinson
Frequent Visitor
8 years ago
Solved

Assistance Needed to create relationship

 I have three tables whereby I need to create a relationship.  fgs_subscriptionorders, fgs_subscriptionitemsesActive and gap_powerbioptionsetrefsprogram. fgs_subscriptionitemsesActive are the ch...
Need Help
  • wperkinson's avatar
    wperkinson
    8 years ago

    Thank you for the reply.

     

    I was able to resolve my issue by creating a merge of the two tables in question.  In this way I could create a relationship between the merged tables and the third table in question.

     

    Regards,

     

    Will

Anonymous's avatar
Anonymous
Not applicable
8 years ago

wperkinson,

Could you please share dummy data of the three tables and post expected result based on the dummy data? Also we need to know what field you use to create relationship among the three tables.

In addition, when you drag program name field of gap_powerbioptionsetrefsprogram and child item field of fgs_subscriptionitemsesActive in a table visual, do you get desired result?

Regards,
Lydia

wperkinson's avatar
wperkinson
Frequent Visitor
8 years ago

Thank you for the reply.

 

I was able to resolve my issue by creating a merge of the two tables in question.  In this way I could create a relationship between the merged tables and the third table in question.

 

Regards,

 

Will