Set Variable $cat = Expenses::ExpenseCatagory
Set Variable $meetingroom = originaltable::MeetingRoomID
Go To Layout Expenses
Perform find; ExpenseCatagory = #cat and MeetingRoomID = $meetingroom
That works, thank you.
One strange thing though ... my Trailing Group on the MeetingRoomID field doesn't appear in the found set, there's no grouping at all.
Any way to get that happening?
you may have to add a sort step to get the grouping and summaries to work