I am working on a fairly basic form for placing orders.  There is a lookup field from which the client can be selected, and a subform containing order items.   As the products which can be ordered are unique to each client, what I am trying to do is to have the "Product" lookup fields within the subform only display products from the selected client.

To achieve these I have added a client lookup field in the subform, and when the client is selected manually the product filter works as expected, displaying only their products.

However, when I try and automate this - by using the code "row.Client = input.Client;" within "On Add Row" - the Product filter is not updated.

Any suggestions on how to achieve this transparently?  I am aware I could use a picklist rather than a lookup but I'd rather not, as it would be a bit of a messy affair - two different fields (product code and product name) need to be displayed on the list, while the ID of the product is the value of importance and I'm not sure of a way to do this using picklists?

Regards,

Chris