Database organization one-to-many(?)

Thanks for the response. It is more or less, just that in the first RG the constraint doesn´t work anymore. Instead of showing the damage requests for which no offer has been done yet, the whole table stays blank now.

it also seems to be a bit different than you described in your earlier post, would be great if you could explain it later for sure!

Thanks for making the effort to still respond regardless of the time, appreciate it a lot.

Kind regards,
Timon

I had a very quick look. The first RG has no constraints so it is showing all requests.

If the intention is for it to show only requests with no offers at all, then you can simply add a constraint: Offers is empty

If the intention is for it to show only requests that the current user (shop) has not put in an offer for, then you need a constraint on the search that is something along the lines of Offers doesn’t contain … (do a search for offers created by current user).

Yeah that’s the intention. The idea in the end is that a repair shop only sees those damage requests which they haven’t done an offer on, or already removed from the list due to a lack of interest in the damage request.