UserImage.jpg
Alberto Santos
36Views
5Comments
Solved
Many-to-many relationship
Question
Beginner
New to OutSystems
Application Type
Traditional Web
Service Studio Version
11.54.28 (Build 62889)
Platform Version
11.24.0 (Build 41209)

Hello, I am a beginner in outsystems,


I would like to make a relationship between my Professional and Specialty tables, but I will have to create a new Professional_Specialty table. I want to register my professional directly just by selecting my specialty. how would I do this, using this new table created (Professional_Specialty)?

0
0
18 Oct
Solution

This has not much to do with OutSystems but more with generic database modelling. You solve this issue the same way in OutSystems as you do in any other SQL database. You can read about the different relationships here: https://www.tutorialsteacher.com/sqlserver/tables-relations

The main question I have for you is, can one or more persons have one or more specialties? 

See solution in context
0
0
18 Oct

Thank you for your reply,


 I was thinking of making a system of hospitals where my professionals can have more than one specialty.

 I'll read up on relationships,


thank you.

0
0
18 Oct
2018-04-25 01-26-43
Amit Verma
Champion
Solution

Hi,

Please look into this post many-to-many relationship

Hope this will help :)

Thanks,

Amit

See solution in context
0
0
18 Oct

Thank you for your reply,

 I'll read up on relationships,

0
0
18 Oct
Solution

This has not much to do with OutSystems but more with generic database modelling. You solve this issue the same way in OutSystems as you do in any other SQL database. You can read about the different relationships here: https://www.tutorialsteacher.com/sqlserver/tables-relations

The main question I have for you is, can one or more persons have one or more specialties? 

0
0
18 Oct

Thank you for your reply,


 I was thinking of making a system of hospitals where my professionals can have more than one specialty.

 I'll read up on relationships,


thank you.

0
0
18 Oct

There is also a great OutSystems training on this topic. Check it out :) 

https://learn.outsystems.com/training/journeys/modeling-data-relationships-642


0
0
18 Oct
2018-04-25 01-26-43
Amit Verma
Champion
Solution

Hi,

Please look into this post many-to-many relationship

Hope this will help :)

Thanks,

Amit

0
0
18 Oct

Thank you for your reply,

 I'll read up on relationships,

0
0
18 Oct
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.