May 3, 200817 yr hello all i have a portal showing results of drug tests. it works fine except that it show tests which do not have any results [clinic visits]. so when i load the layout, it shows patient info [parent layout and table], related tests [in portal one] and related results [in portal two]. i want to show all the tests in portal one [working fine] but i only want to show results of the tests which have anything but clinic visit in tests. how can i omit/filter out "clinic visit" result-rows from the portal. for example PATIENT ID : 7 ============== TEST PORTAL [shows these records] =============== CLINIC-VISIT,DATE,ETC CLINIC-VISIT,DATE,ETC HEARING,DATE,ETC ECG,DATE,ETC =============== RESULTS PORTAL [should show these records only for patient # 7] =============== HEARING,DATE,ETC ECG,DATE,ETC omitting / filtering out CLINIC-VISIT ROWS from RESULTS portal. as you can see from the above example, i want to find and filter out/omit all the rows [from results portal] with CLINIC-VISIT listed in them Edited May 3, 200817 yr by Guest
May 3, 200817 yr ...it works fine except that it show tests which do not have any results [clinic visits]. If I understand correctly, and if you have the proper relationship, then you can place the Results portal on the Patient layout directly. Since your Results table doesn't have a record for CLINIC-VISIT, then they wouldn't appear in the portal anyway. If there are fields from Tests table, you can place them within the Results portal as well (because Tests will be the parent to Results).
Create an account or sign in to comment