Hello all - I’ve been wrestling with this all day and have not been able to solve it. I hope someone has done something similar as this should be a fairly straight forward routine.
I have a Customers table (primary field is CustomerName) and an Orders table (primary field OrderNumber). They are related through a CustomerOrders field in the Orders table.
I would like to list all the orders for a given customer.
I found a forum topic that used advanced filters and I thought this was the closest to my problem. I’ve set up a repeating group that looks for orders based on a CustomerName that I’ve set with a custom state named customername which is part of the page state customerdetails.
This returns nothing in my repeating group.
Any assistance to point me in the right direction would be greatly appreciated.