Mark the asset review record with whether a request exists or where and when it was sent.
Route asset reviews and link each request to its review row.
Your campaign reviewer gets the right file and question, while the review row keeps a link to the request.
Link an open review request to its matching asset version.
Your asset row shows whether the current file version already has a review request, so your team can avoid asking twice.