Can you create a view that combines data from multiple tables?
Then use that table for your clincial reminder