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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Correction: How to perform searches in a 1-to-m relationship?

May 5, 200718 yr

Hallo,

I have a simple database which consists of two objects: “schools” and “teachers”.

The schools (master file) are related to teachers (related file) through a 1-to-many relationship with the school name as match file. So there are many teachers in one school.

No I wanted to perform the following searches:

I wanted FM to display all teachers with the attribute “female” who work in schools with the attribute “southern region”.

On the other hand I wanted to see all schools with the attribute “sport facilities in the school yard” that have teachers with the attribute “part time employees”.

I thought that I was enough to put the teachers file as a portal in the schools file and to go to the search mode. But I did not succeed as the search has failed.

What can I do to perform such kinds of search?

Thank You

Ralf from Uganda

???