AutoSearch (dropdown combo) for Master-Detail

rbuser

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

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