Drop down search box with navigation form

[sgray]

Hi,



I have a form with a dropdown box to search for customer details by name. I want it to display this information along with related information from three diffrent tables. There is alot of information and it needs to be organised in a logical way.

I have added a navigation control that shows the three related tables as forms however the information is not affected by the search and i would prefer this information to be displayed as a table rather than a form.

How do i make the navigation control only display information related to the search and can i display this as tables.

Thanks

[June7]

Would have to know a lot more about your data and forms. Do you want to provide project for analysis?