A given song can be performed in many gigs and a given gig performs many songs.
That makes this a classic many to many relationship.
Songs::__pkSongID = Gig_Song::_fkSongID
Gigs::__pkGigID = Gig_Song::_fkGigID
For an explanation of the notation that I am using, see the first post of: Common Forum Relationship and Field Notations Explained
To set this up, you port a portal to Gig_Song on your Songs layout to see a list of all gigs where that song was/will be performed. Fields from Gigs can be added to the portal row to show more info about each gig. In the same manner, you can add a portal to Gig_Song on the gigs layout to see/edit the list of songs selected for that gig with fields from the songs table included in the portal row.
Many thanks for this.
I've added a Gig_Song join table and related song to gigs and vice versa.
After this I'm confused I'm afraid!
I'm trying to get a portal on the gigs table with a list of songs, but it still duplicates a record to the songlist when I add a song.
Sorry to be so dense!!
Make that a portal to Gig_Song not a portal to songs and it won't duplicate a record to the song list table.
Many thanks. I still can't get it to work though :-(
- I've got a join table with SongNo and GigID, related (=) to the field in the Song and Gig table.
- All the create in this table tick boxes are ticked.
- I've got a portal in a Gig layout set to show related records from GigsSongs.
- I've currently got SongNo, SongTitle fields from Songs table in this portal with a drop down.
I'm able to change existing songs using the drop down, but the SongNo doesn't change to match.
I'm not able to add songs - the dropdown doesn't work on the bottom record.
Sorry to be continually dense!
I cannot download from the 4Shared site without creating an account with them--which is one reason why I no longer use them for sharing files. The other reason is the large number of obnoxious ads and ad links that deliberately look like the actual download link.
I much prefer using DropBox for sharing files as it is: 1) free, 2) there are no download delay counters and 3) no ad links popping up when you go to download a shared file.
Many thanks. I think I saw another link on here to 4Shared so created an account with them specially!
I think I've got it cracked now; the portal's working nicely & I've set up a couple more.
No to be able to send an email to the musicians in the portal.....!