Help! Trying to link two portals
I'm hoping someone out there can help me. I'm trying to create a database to track vet visits for pets. The main database contains info about the pet. (Name, sex, type, etc), the second database I want to contain just the date for the visit to the vet. And the third database will contain the procedures done during the visit. My form is based on the first table, I then create a portal to display the dates of the visit. I then create another portal to display the procedures. My issue is, that when I click on a date in the first portal all I want to see in the second portal are procedures done on that specific date. But it is showing all procedures for the specific pet. How do I filter the second portal to only show the related records?