I am trying to do something that is possibly a bit strange.
I'm working on something where people can book items out, but when they book an item, the system should suggest other items that people usually book with this item. eg. if you book a camera, you probably also want a tripod, some lenses and a bag.
So it seems what I'm trying to do is create a many to many relationship with two parents of the same type (items). My first thought was to create an intermediary post type, which would have a field for the original item, and then another field for an 'accessory item' and a third field for the amount of accessory items. eg if you book a certain camera, then you probably want to book two batteries that fit the camera, one tripod and 3 memory sticks. Each of these 'accessories' would have a post with the original item id, the accessory item id and the amount. So then when someone booked an item, I can check the intermediary posts to see if there are any accessories for this item and how many are recommended.
It doesn't seem possible though to have two parents of the same type. Is there another way I can do this?
