Hello,
this might be a dumb question and I feel like I should know this, but I'm a bit lost.
I have got this database:
- tblInvoices
- tblTaxDocuments (for advance payments)
Every tax document needs to be eventually included in an invoice.
Every tax document can only be included in a single invoice, and an invoice can contain multiple tax documents (therefore typical 1:N relationship).
I have a form for invoices: frmInvoices.
What I want to do here is to have a subform to enter one or more tax documents that should be included with this invoice.
Of course I know how to do it the other way around: open frmTaxDocuments, select an invoice via combo box and that's it. But I want to do it from frmInvoices (the "1 side", not the "N side").
How should I do this subform? I only want to select tax documents (assign InvoiceID to them), not modify the original records.
Thanks a lot in advance.
Tomas