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.

need help defining relationships

Featured Replies

Happy New year all! I've read the whitepaper for novices and went through the FM help & am designing my first database on paper before I create it.

I have a table called ShiftSuper that contains the shift supervisors first name, last name and employment anniversary date. I want to be able to create a performance report for shift supervisors that will give them data on their performance in specific areas, such as overtime management. I have a table called OTMonitor that includes field such as pay period ending date, overtime worked by the shift supervisor department (as a whole) during the pay period and overtime worked by line staff for the payperiod. I also have a table for overtime worked by individual supervisors for the pay period called OTMonitorIndiv. It also has fields for payperiod ending, the supervisors first & last names and OT hours worked for the payperiod.

If I want to be able to generate a report for an individual supervisor that gives them data on their individual OT and OT for the supervisor & line staff departments would I create a relationship between my ShiftSuper table and both the OTMonitor & OTMonitorIndiv and then edit the relationship as shown in the FM Pro help example here http://www.filemaker.com/help/07-Related%20files9.html?

Would making portals from the 2 OT tables on the ShiftSuper report layout be the way I get the OT data to display on the supervisor report?

To search by a range of dates (like their evaluation period or by a specific quarter)on the ShiftSuper table do I have to add a special field(s)? From looking at the FM Pro help, it looks like I need to add a "StartingDate" & "EndingDate" field to my ShiftSuper table. Are these just date fields?

Any advice to help this newbie would be greatly appreciated. Thanks.

Create an account or sign in to comment

Important Information

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

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.