Is there a way to use the addTableFilterParam to filter a table, based on its related records in a link table?
For example, I have 2 tables
Calls (which has a CallID, lengthOfCall, etc)
DeviceCall (which links with CallID, and also has the phone extension number since a call can go across multiple extension)
So, I want to only allow a user to only see records from Calls, that has a related DeviceCall record on a specific extension.
FYI, I’ve tried doing a query on DeviceCall, and passing the CallID values into a statement to addTableFilterParam on Calls, based on the CallID, however, there are THOUSANDS of records returned back…so it obviously doesn’t work.
Hate to say it, but another popular desktop database program allowed us to do it (please don’t shoot me)