i have a dataset that contains 4 tables
all of the table have relations
Companies(UID) - Contacts(UID) 1 to many
Contact(UCID) - QUotes(UCID) 1 to many
Quotes(Quote_Number) - QuoteDetails(Quote_Number) 1 to many
the data on my form uses binding sources to display the data.
I am wanting to allow the user to filter the data by a number of different methods.
I can easliy filter the data by company name for instance bsCompanies.filter = "company like 'dir%' but how could i filter to bring back all the companies that have had a quote in the last 2 months for instance
I hope this makes sense