song preview and album association

I have ps3 setup to deliver digital goods no problem! My client is selling music, if there selling the full album everything works just fine. I want to be able to ,on the Product detail page to have customers have the option to buy the full album or individual songs. So I know i enter the full album as a product, and each song as a product. How can i associate all the individual songs with that album. I have almost all the webassist products and good web design knowledge (php, sql, etc.), i relize its probably a database table relationship thing, i just need to be pointed in the right direction. I understand products related to categories how would i associate products with products.

i guess you could create a linking table for this

albumsongs:
albumSongsID - primary Key
albumSongsAlbumID - Enter the ProductID for the Album product
albumSongsSongID - Enter the ProductID for the song product


create a separate record for each song to relate it to the album


then to return the songs that relate to the album, you could use the following query:
SELECT * FROM ps4_products where ProductID IN (SELECT albumSongsID from ps4_products INNER JOIN albumsongs ON ps4_products.ProductID = albumsongs.albumSongsAlbumID WHERE ps4_products.ProductID = <Album productID>)

ok i pretty much have it set up. How would i insert product id in the "albumSongsSongID" table every time i add a a new product

you would need to add an update record behavior for this to update the albumsongs table.

ok am on the product insert page, from server behaviors i've chosen dataassist update single record update how do i chose my value to be productID when creating a new product am choosing from my update record (ps3_products) form

I observed that all the round edges in PS4 appered nice and perfect in Safari, Mozila but it doesnt work in Explorer. Every appears rectangles. What can i do to have the same round shapes in Exporer

You wont be doing this on product insert.

you will need to create a whole new page to select the album product then probably have a multiple select list that allows you to select all of the song products that should be associated with the album and insert the ids to the new albumsongs table.

you are going to have to do some custom coding to get this to work, and is not something that we can offer support for.

can i submit a premium ticket for this

sure, you could start a premium ticket for help with this.