Hi all. I have a custom tab working on the Constituent record that shows custom Event info and I want a dropdown that shows meal options per campaign_no (event). My dropdown subreport looks at a view that shows all meal options for all events. The problem is the dropdown is also showing all meal options not just those for the one event. And if I add a campaign_no retrieval argument to the Infomaker subreport, the drowndown on the custom tab then shows NO meal options.
Is the problem with my meal option field on my main custom tab report? On the Edit tab I have Display Column and Data Column both looking at the same meal_pref_desc string field, because that's what I need it to insert into the column, a string value.
I've followed the Custom Tab doc and looked at various other documentation and forums and can't seem to solve this problem.
If anyone can clearly see what I'm doing wrong, thanks in advance!