I'd suggest taking a look at whether you really need three tables/files for this. You might be able to store all dentist, staff and hygienist records in a single table--that makes your report much easier to create.
It sounds like you have at least 4 tables/files here maybe more as you may have tables for patients and billing.
What version of filemaker are you using?
What does this report need to look like?