August 3, 200916 yr Hi - I am an intermediate FM 10 user on a windows platform and I want to create a List layout displaying information from a portal - but the list only displays information from the first row of each portal. I would also like to produce a summary report, but the same result occurs - only information from the first portal row is displayed. Each row of my portal contains: Med_cat, Med_name, Dose, Date_initiated, Date_Discontinued. ...and each patient might be on a number of different medications (and may also discontinue one med. only to start again at a later date). I have the portal sorting by Med_cat and Date initiated (with conditional formatting making each medication category a different text colour - just for ease of immediate recognition...) I want to produce a List layout as follows: Patient_ID, Patient_name, Med_cat, Med_Name, Dose, Date_In, Date_Dis Initially I tried displaying the medications info using repeating fields but that turned out to be space and time consuming and virtually impossible to maintain (not to mention confusing for data entry!). I found using a portal an efficient method both for primary layout display and for data entry purposes. Any help with a solution to get the List Layout (and/or summary report) to display all portal rows for each patient would be greatly appreciated. Cheers, Rramjet. PS: I do not want to have to return to repeating fields if at all possible :
August 3, 200916 yr Your report would have to be based on the child records. In this case I am going to assume that it is the Medicine table. You can put the related parent patient Info on it. You can create a subsummary report if you wish grouped by patientID. You havent specified your structure, so I can only take a guess here.
August 3, 200916 yr Author Hi John - Please forgive me for my naivety! - for the report I was not pointing FM to get the info from the correct table! FM was trying to get the info from the parent (Patent_Details) table when I should have pointed it to the Medication_Details table. Sorry. Now I have a report displaying all portal info... ...but I still do not have a List Layout displaying all portal info. Maybe I being just stupid here too? I'll work on it some more... humbled thanks, Rramjet Edited August 4, 200916 yr by Guest
Create an account or sign in to comment