Hi,

I'm making a sales and invoicing system, but I'm struggling with the credit
notes.

So far, I have set up the sales orders and sales order lines in two separate
tables.

Same with the credit notes, and credit note lines.

The credit note is based on a sales order, but doesn't necessarily contain
all the same lines as there were in the sales order.  Therefore, I need to
pull through a copy of the sales order lines into the credit note lines, and
then edit from there.

How do I pull a copy of the sales lines for a particular sales order through
into the relevant credit note lines table associated with the original sales
order?

Thanks,

Franc.