Forum Discussion

heidibb's avatar
heidibb
Helper IV
9 years ago

Issues Creating a Relationship

Hello,   Please see my model in the image below. I am trying to create a relationship between a few of these tables and a WEEK table.   My WEEK table has one column for WEEK with the values of 1 ...
Need Help
Jorre94's avatar
Jorre94
Advocate II
9 years ago

heidibb

You can create another table with weeks.

for example:

 

 

Week 1| Week 2| Week 3|

  1        |    1       |     1     |

  2        |    2       |     2     |

  3        |    3       |     3     |

  4        |    4       |     4     |

  5        |    5       |     5     |

  6        |    6       |     6     |

  etc.

 

Then you create a relationship between the different week columns.

 

for the one above Week 1

In the middle Week 2

And the one below Week 3

 

Regards,

Jorre

  • heidibb's avatar
    heidibb
    Helper IV
    9 years ago

    Thanks Jorre94. I thought that would solve it but I'm still getting the error stating that it would "introduce ambiguity between tables WEEK and BB_RPT FACULTY. To make this relationship active, deactivate or delete one of hte relationships between WEEK and BB_RPT FACULTY first."