Thank you for reading my message !
I’m encountering an issue I don’t understand, as it should be pretty straightforward. Maybe one of you may help…
The “Event” table is Linked to the “Invoices” Table, through the Invoice_ID’s linked record (see below) :
An Event can have multiple invoices attached to it (as in multiple attendees). However in the above screenshot, the Invoice ID that you see IS NOT in the “Paid only Invoices” View, and appears anyway in the Linked record field which, as far as I understand, should not :
My idea is to manage Event stock with Paid only invoices, so for me it would be very practical to have this information on this table.
Thank you or your help with this !