1 of 1 people found this helpful
In the relationship for the portal have Enable for creation of records through the relationship. Then add the two fields in the portal
I Want Add 2 Artist On Portal For Example : (Amirabbas Golab - Bombe
Jonoun) On Artist Field & in Featuring Field (Alireza Azar )
This Means Amirabbas Golab & Alireza Azar Must be Have This Song On Portal
And They Are separate َArtists And They Have Own Record.
Can You Do This For Me On My Project And Send It To Me And Then I Can Be
Learn It So This Is Hard For Me Right Now I Know What I Want But I Can't Do
You need following tables
The middle table ArtistSong is where you just store unique ID from Artist and Song so the relationship will be
Artist -< ArtistSong >- Song
-< = One to many, one artist can have multiple songs
-> = Many to one, one song can be performed by several artist
With this you can setup your solution like you are asking for.