I have three tables:
Clients, who have many
Files which each have many
The tables are therefore linked that way.
I want to have cleints as the main form
That form will be tabbed.
On the first tab will be a Files. I have had no problem in building the subform
On the second tab will be invoices
What i need is the best way to do this:
To click on a File in the subform (first tab) and go to the corresponding Invoices on the next tab, and to be able to create a new invoice ID etc
There would there for be a clickable link from the (say) file ID to the invoices for that file.