Look up field to display report link?

Hi

I am trying to have a lookup field trigger a report link.

Here is what I have:

Table 1- Room Types - This is lists different conference rooms typed e.g. Small Conference room, Huddle room etc
Table 2 - AV Systems - This is a database of all of the possible AV systems that would go into a conference room
Table 3 - Registrations (ignore the current name as it will be changing) - This is where I can create a combined record adding multiple AV Systems to one Room Type.
Table 4 - List Items - This is where I want to have a report link called Room BOM List that shows all Registration items based on a lookup field for Room Types. Example: If I select from the drop down lookup field Related Room, Small Conference Rooms, the report link would only show me Registrations for that room type

I already have the tables setup along with their relationships. Everything is working as desired except for the report link Room BOM List with the lookup field

-Room BOM List is a report link with Related Room as the local field and Registrations: Related Room as the target field. Both are numeric
-Related Room is a numeric lookup field

I hope this is somewhat clear. Below are some screen shots-

Thank you for your assistance

------------------------------
Charles Wade
------------------------------