I have used the advanced query on the SaleTable form to link the SalesLines table to the SalesTable using 1:N. When looking at the fields in SalesLine, not all of the table fields are visible. Specifically, I am looking or RemainSalesFinancial. What controls the whether fields are available using this query tool?
*This post is locked for comments