I need to store a list of different properties with quantity for each custom post. For example, list of properties: «aaa», «bbb», «ccc», «ddd». Posts: «foo» and «bar»; connections: «foo — 70% aaa, 20% bbb, 10% ccc», and «bar — 50% bbb, 30% ccc, 20% ddd». I want to be able to select all posts with «bbb» property, but how could I store its quantity?
If I create three text fields plus three relationship fields, I will not be able to filter by all three of them.
In a perfect SQL world it would be a join table with one extra column for quantity, but how would that work with Pods?
- The topic ‘Many-to-many relationship with an extra field’ is closed to new replies.