Populate Pull Down Menu

I am trying to populate the pulldown menu on a custom active report. I thought all I needed to do was to fill in the DrillDownFieldName section with a (Table).(Column) value hence

DrillDownFieldName = "Tender.Description"

But this isn't doing to job.

Any help would be appreciated.

Patrick

Reply to
Patrick
Loading thread data ...

Patrick,

Using the stock Tender Summary report as an example;

Add your JOIN statement in the Tables Queried statement;

LEFT JOIN Tender ON TenderEntry.TenderID = Tender.ID

Change the Fieldname = "Tender.Description" Change the DrillDownFieldname = "Tender.Description"

Reply to
Jeff

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.