Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Doing a find in a one-to-many relationship

OASES
in Finding & Searching

Featured Replies

This problem is hard to explain succinctly, so I'll explain it in detail. I have Tutee & TuteeProgramHistory (TPH) files that are related by a unique serial. TPH keeps track of the semester, year, and program the student is enrolled in. Tutee has a portal to show the many programs the student is in. My problem currently is when I try to find students enrolled in Fall 2001 tutorial (it should give me no results), I get most of my students because they are enrolled in Fall programs and 2001 (Spring) programs (the frustration of doing searches in portals, it looks for any combination). Someone told me the search needs to be done in the TPH file, but then I can't import those search results back to the Tutee file so that I can view all the other programs the tutee is in. What's the best solution? If something needs clarification, please ask. Thanks.

quote:
Originally posted by OASES:

This problem is hard to explain succinctly, so I'll explain it in detail. I have Tutee & TuteeProgramHistory (TPH) files that are related by a unique serial. TPH keeps track of the semester, year, and program the student is enrolled in. Tutee has a portal to show the many programs the student is in. My problem currently is when I try to find students enrolled in Fall 2001 tutorial (it should give me no results), I get most of my students because they are enrolled in Fall programs and 2001 (Spring) programs (the frustration of doing searches in portals, it looks for any combination). Someone told me the search needs to be done in the TPH file, but then I can't import those search results back to the Tutee file so that I can view all the other programs the tutee is in. What's the best solution? If something needs clarification, please ask. Thanks.

There are almost 2 ways to bypass portals in related searches; very relevant is to know the right composition of your 'unique serial' that collates the two tables (i.e. "2001F", where 2001 is obviously the year and F stands for the Fall season).

Being strongly involved in this problem i wish i can provide you a resolution.

Create an account or sign in to comment

https://fmforums.com/topic/374-doing-a-find-in-a-one-to-many-relationship/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.