I am new to wix code. I am setting up databases and need direction. I have tried to follow the directions but am a little confused. Here is what I would like to do: I have events that have assets to be used at each event. The same asset would be used at multiple events. Events are unique whereas assets repeat for each event.
I would like to set up a database where I record what assets were used for each event. Then I would like to set up a dynamic item page for each event and list the assets used for that event. Then I would like a dynamic item page to show each asset and then what events those assets were used in.
I am having trouble learning how to do this. I am not sure if I should have an event table, an asset table and then link them? but not sure how to link?
Since there are multiple assets for each event and it is not one to one relationship, I will have the same event repeated in the database for each asset used.
I want my dynamic item web page to only show the event once and all the assets used for that event
thank so much!