Help creating a Link Table

[jampierre]

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

[kaushiknsolanki]

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

[jampierre]

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

[jampierre]

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