Relationship for students- programs and payments for specific programs

[agtjazz]

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

[mr_vodka]

You would want the payment to be applied to the actual class that is assigned to a particular student.

StudentPayment.zip

[agtjazz]

Thank you... I will take a look

Your time and helpfulness is greatly appreciated!