Crossing tables

[Arcanoi]

I am currently designing a database where I have one table with classes and one table with students, I need to know how to get the Cost of the classes from classes and do a total owed amount on the student, any help would be aprricated.

[-Queue-]

Relate Students to Classes by unique student id. Then you can create a Sum(classes::cost) in the Students table.

[Arcanoi]

Thank You Queue as always...

[Arcanoi]

New problem if the still owe money... I currently have the field go

Balance = Total_Amount_Due - Total_Amount_Paid

I need to have a flag either a graphic or Red text come up and say that they haven't paid.

[-Queue-]

I assume you mean you want the flag to appear in a different field. You could do it like

Case( Balance > 0; graphic )

or Case( Balance > 0; TextColor ( "Unpaid" ; RGB ( 255 ; 0 ; 0 ) ) ).

[Arcanoi]

Yes a flag in a diffrent field I'll try those out and see if they work.

[-Queue-]

To clarify, graphic would be a global container field containing the desired graphic.

[Arcanoi]

How do I set the graphics field in layout mode? I am confused on how to make this work.

[Arcanoi]

I figured it out thanks anyways