My QB has a table of "Invoices". Each month the users "copy" the invoice for the new month. Most fields stay the same, including a list of children "Lines". When they copy an invoice, the child lines are not also copied. Why is this?
As per many-to-many rules, I created a "hidden" Invoice-to-Line table that is just the "Related Invoice" and "Related Line" (and the fields in the relationship). I guess I need to have QB create new entries in Invoice-to-Line when an Invoice is copied, with all of the Lines connected to the new Invoice.
Is this possible? (An Invoice can have up to 200 Lines, so this is a requirement for the users.) How do I implement this?
Thanks in advance!