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.

I think I need a self-join TO? Please help

Jimjmn
in Relationships

Featured Replies

I will start with a novice apology. I am wanting to create an employee records DB and each employee will have a manager listed. That being said I would like to be able to list all employees that a employee (manager) has under them in a portal (see attached file). I have played with _pk and _fk to no avail. What am I doing wrong? I'm thinking this is easily achieved with a self-join but maybe I need an join table?

test.fp7.zip

  • Author

You are the man Bruce. Thanks so very much!!!

Create an account or sign in to comment

https://fmforums.com/topic/72876-i-think-i-need-a-self-join-to-please-help/
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.