How to add linked records to a subform?
Hello,
I do have a custom module "Subscriptions" and I want to add every single invoice that is attached to a subscription to a subform.
So every subscription contains several invoices. Each invoice will be added to the subscription after the subscription has been renewed (the idea is that a new invoice will be issued/added every year).
The invoices do have a field named "Subscription_Number" which is a lookup field that links to the Subscription. And if the invoices belong to the same subscription they do have the same value in the field "Subscription_Number".
The subscription has a subform and I want to add each invoice with a new row/record to the subform. The subform has the following fields (the values will be taken from each invoice):
- Invoice_Number (a lookup field)
- Invoice_Date (a date field)
- Invoice_Type (a picklist)
How can I do this?
Thanks for help,
M.