I have 3 tables.
- Corrective (with an “Is a part of” reference to Invoice)
- Tracking Number (A number that appears on all other tables)
Both 1 and 2 reference 3
So the process goes like this.
- You make a Tracking Number say 2021
- You make a Corrective (or many, lets say 5 of them) and one of the fields asks for the Tracking Number (2021)
- You can make an Invoice, where if you choose you can create more Correctives.
I cannot figure out how to have the Corrective entries that are not created from the Invoice form appear. I would like all correctives with the same Tracking Number to appear on the appropriate Invoice. So in the above example, the invoice for 2021 would have 5 correctives.