Expand all | Collapse all

Look up field to display report link?

  • 1.  Look up field to display report link?

    Posted 16 days ago

    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

  • 2.  RE: Look up field to display report link?

    Posted 16 days ago
    When you're using an embedded report in this way, the display would only change once the record you're on has been saved. In the 2nd image of the Form, are you saving the record and still nothing shows?

    Blake Harrison
    DataBlender - Quick Base Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/

  • 3.  RE: Look up field to display report link?

    Posted 16 days ago
    No I haven't tried saving it. That's not the desired workflow.

    Is there a way to display the report without having to save it?

    It's the same report that I use in the room types table. When I select a specific room from that table the report shows all of the registrations associated with that room type.