AutoSearch (dropdown combo) for Master-Detail

rbuser · May 2010

We have the following master - detail relation in the data base:

Master...
EventName (ascii string)
EventID (unique ID for each Event Record - RecNo)

Detail...
EventDetailLinkID (unique ID for each Event Detail Record - RecNo - maps to
EventID field in Master table)
< other EventDetail data fields >

How do we construct an AutoSearch so that the user can select the EventName
from the Master table and only display records from the Detail table
(Detail.LinkID = Master.EventID)?

We want to display the Event Name in a drop down combo box and only display
detail records that belong to that selected Event.

Thanks, Patrick

nicocizik · May 2010

Hi Patrick,

This can be done using the parameters feature of ReportBuilder.

1. Create a new parameter using the report tree and assign its value
properties and autosearch properties. (you can assign it a lookup list
attached to a data field).
2. Create an autosearch field in the Query Designer in DADE and use the
newly created parameter as the value.

Take a look at the following article for more information.

http://www.digital-metaphors.com/rbWiki/End-User/Fundamentals/Report_Parameter_Fundamentals

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com

AutoSearch (dropdown combo) for Master-Detail

Comments