0

Filter a view by Id

Hi Again,
We need a little help filtering a view.
The view is in an appointment table and selects/views the invoice table lines.
I’m trying to filter only the lines associated with the current Appointment Id.
We do not want to manually perform the filter each time there is a new appointment/invoice.
The results of the code used yields the first Id not the last/current in the line table.
Anyone have an easy fix to this code?

(select AppointmentLine)[Appointment.Id]

Thanks 

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 1 mth ago
    • Reported - view

    If you are in the appointment table then:

    let t := this;
    (select AppointmentLine)[Appointment = t]

    If you are in some other table then you can just adjust the t to include the path to the Appointment table (a reference field, or dymanic choice/multi choice, etc).

    Like
    • Sam
    • Sam.1
    • 1 mth ago
    • Reported - view

    Works perfect⭐
    thanks again Fred!

    Like
Like Follow
  • 1 mth agoLast active
  • 2Replies
  • 28Views
  • 2 Following