Thank you for your post!
I am going to move this thread from the FileMaker Community Feedback Space, which is specifically for input on the Community itself, to the Discussions Space where you should receive more views and potentially more advice on this topic!
1 of 1 people found this helpful
Why do you need the join table?
From your description, it appears that you have this relationshp:
I make that conclusion because you describe searching for Therapy_Notes by Invoice ID.
A join table would enable you to link one Therapy_Notes record to more than one Invoice. Is that something that you actually need to do here?
Seems to me that once you have that find performed, all you need is a layout based on THerapy_Notes where each record is a row in a list view with fields from Invoice included in the header and possibly a footer or trailing grand summary to be able to print out an invoice for that client.
Thank you. Sorry for the late response. I went with your advice and scrapped the invoice system I had going. Your method simplified the process.