July 29, 200421 yr Hi gang, FM 7Pro with IWP (OSX). I have a form with a portal showing related records. The related records are from a self-joined table (Medications is the original table, Medications 3 is the self-joined table, PatientID=PatientID and Yes=Active are the match fields, this is to select only those entries from the Medications table that match the current patient and are active medications). The form works properly within Filemaker, but when accessed by a web browser, the portal does not display initially. If I click on the button which is programmed to add a new medication record, the portal displays and I see all of the previous active medications as well. After doing this once, the form works properly for all other patients. In other words, the portal does not display when initially accessing the database, but once data entry starts, it works properly thereafter. It is annoying to have to add a new record, as usually all we want to do is view the current medication list. Any ideas? Cheers!
Create an account or sign in to comment