When the lookup value is a field with multiple records, is there a way to filter the returned linked records and extract one field from it?For simplicity's sake, suppose that I have the following 4 tables1. Products - generic information about produc...
Thanks. I suspected that would be the case. The main reason I didn't do that is that some products have stable prices and availability from vendors and can be automatically pulled, others are bespoke and I'd like to manually choose the product, v...
