AutoSearch (dropdown combo) for Master-Detail

edited May 2010 in DADE
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

Comments

This discussion has been closed.