Does anyone know of a way to filter two equal fields? i.e. On the customer table, I want to select all records where the no. is the same value as the bill-to customer no. I don’t want to filter values, I just want to filter equivalence. I can do this in a report, but I want to pass this on to end users. Any suggestions?
From the End User point of view,this can’t be done directly, but since you mention the Report designer, I would guess you also have the Table designer, and can create FlowFields. I have posted a reply in the Developers forum for you if you want to try. http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=14615 This is very simple solution, and you should not have any problem implementing it.