Long winded but hopefully descriptive enough to describe my problem.
I have the following Tables:
They are connected as such
Students table to Ledger table - StudentIdPk > StudentIdFk
Students table to Ledger_Chgs table - StudentIdChgs > StudentIdChgs
Students table to Ledger_Pay table - StudentIdPay > StudentIdPay
Ledger_Self table to Ledger_Chgs table - StudentIdFk > StudentIdFk
These are all used with a layout called Students.
In my students layout I have a portal to Ledger_Pay (and Ledger_Chgs but that's not an issue) In this portal I can create a new record and record the students payments. This works really well. I also have 4 other text fields (DuesPaid, Clinic Paid, Exam Paid and ISKF paid) than I mark either Pd or leave blank when I take their dues or other payments.
Here's my problem
I have another layout (Attendance) not based on these tables but on TO's that shows the students name, attendance daily for the month and phone numbers. I also have text fields for the above mentioned text fields - DuesPaid, Clinic Paid, Exam Paid and ISKF paid that I have been filling in on this layout too. Double work and double the chance for a mistake. I can get the fields to show on this layout from the Ledger_Pay table but not for the correct month/year. When I script a FIND I can go to the Ledger Table and get the correct Month and Year using varibles based on g_Month and g_Year but when I go the the Attendance layout it always shows the last recorded created unless I sort differently. I want to be able to pull up these records for the correct month/year at any time, not just when the month is current. I'm not trying to get fancy financial software or complex book keeping, just to show the records created in one place to display in another. I do have the attendance table connected to a TO of the Ledger_Pay TO but can't get past what will probably be simple to most everyone but me.
Thank you for any and all help,