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.

Relationship for students- programs and payments for specific programs

agtjazz
in Relationships

Featured Replies

Hello

I am having a difficult time getting this to work, and I think it’s just me because in theory it’s very simple.

A student can be in one or more programs. Each program requires payment. There are rules associated with payments (ie If all fees aren’t paid, then deny admission to that program).

I think the relationships should go like this: (not 100% sure though)

Student → Program Admission ← Program Type

Student ←→ Payments

Payment → Program Admission

I want to see the students admissions to program “A” and payments for program “A”. But if that student is also admitted to program “ B” and has payments to “B”, I don’t want to see it on Program “A” record.

I have attached a sample of a database, but it’s not working for me.

Thanks in advance

test.fp7.zip

  • Author

Thank you... I will take a look

Your time and helpfulness is greatly appreciated!

Create an account or sign in to comment

https://fmforums.com/topic/49633-relationship-for-students-programs-and-payments-for-specific-programs/
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.