Searching through related tables

[david.paton]

I have a search function built into my database. Open the form “Start”, then select Search for Legatees. This opens a form where I can search for Legatees by the name. I want to be able to search for legatees by their division also. I tried updating the row source for the list box where the results are displayed but that didn’t work. I know how to search a table for data but I am not real sure how to search a related table for data, as you can see the division is stored as a number and just references another table. How do I get this to work?

Could you also please describe how to do it as I will need to update the working database as I needed to remove a lot of data for privacy reasons? Thanks

 

[bob fitz]

Post back if the attached db doesn't do what you require or if you have any questions about the changes made.

 

[david.paton]

Thanks Bob