While fiddling with stuff I ran into a question.
How can you drill down a query to only show specific things?
To give an example, if I had a quote 12345-20-1, 12345-20-2, 12345-20-3 and 12345-20-4. All the same quote, but different revision numbers. How would I tell a query to only show me the quote with the highest revision number? So the query would only return 12345-20-4?
I do have a linked table that has that broken down into its 3 separate parts if that matters.
How can you drill down a query to only show specific things?
To give an example, if I had a quote 12345-20-1, 12345-20-2, 12345-20-3 and 12345-20-4. All the same quote, but different revision numbers. How would I tell a query to only show me the quote with the highest revision number? So the query would only return 12345-20-4?
I do have a linked table that has that broken down into its 3 separate parts if that matters.