Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have these 5 tables with keys.
TEAM:
ID_TEAM
Activity:
ID_ATTIVITA
ID_TEAM
Resource_Team:
ID_RISORSA
ID_TEAM
Resource:
ID_RISORSA
Resource_Activity:
ID_RISORSA
ID_ATTIVITA
I’m in trouble trying to create e link table.
Could someone help me to create a Link table!?
I will really appreciate
Thanks in advance
Hi,
Before creating data model with Link table, can you tell us what will be the use case of the data.
1. Do you want All activities to be in one field?
2. Do you need resources in single table?
Regards,
Kaushik Solanki
I,
thanks to reply.
I'm trying to explain how it has to works.
table:
Resource_Team: Resources associated to a team
Resource_Activity: Resources associated to an activity
A Team has one or more activity associated
A Team has one or more resource associated
A resource can work on one or more acitivities
Example: Team 1. A resource of that Team is working on activity 1 but not in activity 2
I'd like to see:
1) All the Activities of a team and the resources that can be associated to those activities
2) All the Activities of a team and the resorces that are working on that activities
example:
First table. I'd like to see (team,activity and resources)
Team Activity Resource
Team1 Activity1 Resource1
Team1 Activity2 Resource1
Team1 Activity3 Resource1
Team2 Activity1 Resource2
Team2 Activity4 Resource2
Second table. I'd like to see (Team,activity and resources that are working on that activity)
Team | Activity | Resource |
Team1 | Activity1 | Resource1 |
Team1 | Activity3 | Resource1 |
Team2 | Activity1 | Resource2 |
Hope It's clear.
I'm sorry about my english
Best regards
Hi gurus,
any idea about my post.
How do I have to build the link table?
The problem for me is that Activity and Resource-Activity and Resource_Team have different couple of keys
No one can help me?
Thanks in advance
Best regards