Hi guys, I am having trouble figuring out how to organize my database, so I made this image to clarify everything a bit (maybe it only confuses even more but here we go):
If I understand it correctly I´m trying to build a one to many relationship within my database: A client can make multiple damage requests and each damage request can receive multiple offers. However, each repairshop can only make one offer per damage requests.
One Damage Requests – Many Offers, Every Offer only One Damage Reqeusts.
Where I get lost is how to structure this within my database. I structured it now how can be seen in the image, in which I incorporate the type “Damage Request” as a value in the type “Repair Offer”. As such every offer is linked to a unique Damage Request ID, and I feel it should be like this more or less.
I created a page for the Client in which I want to show which Damage Requests were issued by the Client (Through a repeating group) and then, when selecting a certain Damage Request show, again through a repeating group, which offers were made by Repair Shops. Dave would select Damage Request with unique ID 1, and then see offers from repairshops 1,2,3 respectively, all linked back to him through the same Unique ID which was incorporated as a value within the “Repair Offer” type.
My problem is filtering on the unique IDs which belong to Dave. Let´s say Dave created a request with Unique ID 1 (image) as well asUnique ID 3 (not in image). I would like to make a filter so that all Damage Requests made by Dave will show up in the repeating groups, which subsequently can be selected to show the (in this case 3) offers made by the repair shops.
I hope I made myself clear enough, if not just let me know so I can clarify the situation a bit better.
Thanks a lot!