Share
Report
42Hi,
I have two combo boxes on a canvas app:
cboProducts - items from the products table
cboRoofProd - items from the products table, which are related through table Product Relationships to the product selected in cboProducts
I am struggling to get the second combo box to show the products I need it to show. I can get it to filter down to the only those products in Product Relationships which are related to the product selected in cboProduct, but it is returning the name field which is blank and not much use anyway.
What I need it to return is the 'Related Product'.Product value so I can then filter the product table with an "in", something like this...
I was thinking something like this for the cboRoofProd but this doesn't work and I'm struggling where to go with it now, and the .product at the end of the second filter doesn't return anything, there are only a few options available there such as name, status, status reason etc.
Filter(Products,Product in Filter('Product Relationships',Products.Product = cboProduct.Selected.Product).Product)
All responses (
Answers (
