Hi.
(All my tables are linked SharePoint lists)
I have an InvoiceDetails Query that gets data from InvoiceDetails Table. That data is edited via an Invoice subform.
However, I would also like to get each item's name and category from Stock Table, which is linked to InvoiceDetails Table by barcode, and just showcase it in the subform for every item in an invoice.
Now if I link also Stock Table to the query, it makes the query uneditable. With local tables this didn't happen. Is there a way to get around doing it this way, or is there a better way? Indeed I don't need to edit the Stock table's data in this form.
(All my tables are linked SharePoint lists)
I have an InvoiceDetails Query that gets data from InvoiceDetails Table. That data is edited via an Invoice subform.
However, I would also like to get each item's name and category from Stock Table, which is linked to InvoiceDetails Table by barcode, and just showcase it in the subform for every item in an invoice.
Now if I link also Stock Table to the query, it makes the query uneditable. With local tables this didn't happen. Is there a way to get around doing it this way, or is there a better way? Indeed I don't need to edit the Stock table's data in this form.