Samjsmith Posted April 19, 2008 Share Posted April 19, 2008 Subject: Music Catalog Database 04-17-08 06:56 PM - Post#288342 I am stuck on creating a relationship in a printed music catalog database. I would appreciate any help you can give me. This database tracks printed music. My desire is to create 1 layout and but view music titles with tab views and portals. I want to view the portaled music with the following tabs. Song Details By Occasion By Style By Theme Here are my tables Songs Occasion lineitem Style lineitem Theme lineitem Note that each song can have more than 1 occasion, style and theme. My questions is…can I develop this using only one layout and tabs, or am I going to have to use multiple layouts? Thanks for your help. Link to comment Share on other sites More sharing options...
AHunter3 Posted April 20, 2008 Share Posted April 20, 2008 Multiple layouts, and multiple tables. Songs Occasions Themes Styles and also I would assume... Performers Albums and perhaps... Playlists Genres ? Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts