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
------------------------------
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
------------------------------
