Show flagged birthdays from Accounts table on Census table on all Records
I've got another question thats been stupming me. I have a field that flags for birthdays 7 days or = to the day and month of the clientsdateofBirth on the Accoutns table of Active records. What I would like to do, is have it show them on the Census Table. The Census table is related Via ID_Account and id_account. However, I have a layout on the Census table which shows all of my calculations for the "Active" residents. I would like to display the birthdays on what I call the Census Cover sheet. Since it shows data from all "Active" records, I will need the birthdays to be able to be displayed on all Census records in order to show up on the printed Census Cover page.