AnsweredAssumed Answered

Help With Table set-up

Question asked by nycnewbie on Oct 13, 2009
Latest reply on Oct 14, 2009 by philmodjunk

Title

Help With Table set-up

Post

Hey all! I use Filemaker Pro 10 on a Mac desktop. I am working on a database for a small school keeping track of student info and enrollement. Please check out how I have set up my database....it looks like it makes sense but I'm not able to share info except between STUDENTS, ENROLLEMENT, & CLASSES - as you can see i've connected INOVICE to ENROLLEMENT. I'm having trouble wrapping my head around how to get this to work. I need to be able to take payments for students and customize payment plans.

 

 

STUDENTS
students ID

ENROLLEMENT
classes ID
students ID
Invoice ID

CLASSES
classes id

INVOICE
Invoice ID

JOIN TABLE
Payments ID
Invoice ID

PAYMENTS
Payments ID









Outcomes