Discussions

 View Only
Expand all | Collapse all

Can a record on an embedded report link ""know"" the ID of the record it is embedded on?

  • 1.  Can a record on an embedded report link ""know"" the ID of the record it is embedded on?

    Posted 05-09-2019 16:44
    I have 4 tables with the following relationships:
    Clients < Services
    Clients < Applied Promotions
    Promotions < Applied Promotions
    Applied Promotions < Services

    On a given Service, I have a report link which displays an embedded tables of all the Applied Promotions which are the children of the Service's parent Client. I'd like to create a single button, displayed on the Applied Promotion in the embedded table, which when clicked will make the Service on which the table is displayed child to that Applied Promotion. Any ideas?


  • 2.  RE: Can a record on an embedded report link ""know"" the ID of the record it is embedded on?

    Posted 05-14-2019 19:47
    Hi Jonathan, unfortunately a report link doesn't have a way of knowing the Record ID# of the record it's embedded in. However, it sounds like you're trying restrict users so they can only relate the service to an applied promotion that's related to the parent client. Have you tried using a conditional dropdown for this?

    - Brian