Title
Multiple Records in a Portal
Post
Hello, I'm working through a solution and I've gotten stuck. I run a talent agency and I need to keep track of which of my artists are submitted for a particular project. Often times we'll submit multiple. I'm using a Job ID that carries across the entire databse, the problem is that only 1 entry from my "Submissions" Layout shows up in the portal even though multiple submissions are using the same Job ID #
That might be the problem since you need an artists ID in some of your relationships in order to submit them for a particular job.
And since you can submit multiple artists to a given job and a given artist can be submitted to multiple jobs, this is not a simple one to many or many to one relationship, it's a many to many relationship.
Jobs-----<Submissions>-----Artists
Jobs::__pkJobID = Submissions::_fkJobID
Artists::__pkArtistID = Submissions::_fkArtistID
You can place a portal to Submissions on the Jobs layout to list and select Artists records for each given Jobs record. Fields from Artists can be included in the Portal to show additional info about each selected Artists record and the _fkArtistID field can be set up with a value list for selecting Artists records by their ID field.
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained