April 15, 200421 yr I have two tables, Visits with a record for each patient visit, VisitCharges with many records for each charge for that visit. I have a relationship with the VisitID to the many VisitCharges (VisitToVisitCharges) and a portal works great to show all the charges for that visit. I then have a selfjoining portal from Visit to Visit that works great to show each visit in a horizontal fashion, each column shows one row and has a differing starting row. I then created a VisitToVisitToVisitCharge relationship. My problem is when I place the portal with the VisitCharges in this VisitToVisit portal, nothing shows. I believe I have the relationship correct because when the field is take out of the VisitToVisitCharge portal, it shows the first VisitCharge. Any suggestions? FileMaker Version: Dev 7 Platform: Mac OS X Panther
Create an account or sign in to comment