Show related records in a portal - Filemaker Pro 9.0
Posted on 2011-02-23
Hi, I have customized the Inventory database included with FM pro 9.0. I added a table called "Monitoring" to monitior service / mainenance of differents piece of equipment. That table contains a number of fields and I created one field named Inventory_ID which is the same as the Inventory table. I created a relationship linking these two fields. Inventory::Inventory_ID = Monitoring::Inventory_ID. My problem is when I added a portal on my Inventory layout, the records from Monitoring don't show. I believe my relationship is not right but I can't see why. As you can see, I'm not a Database expert! :o)
As a result, What I'd like to see is a piece of equipment (inventory) showing one or more service calls/repairs on it.