Complex Query question - using distant related criteria

M

markmarko

I've got a challenging query I need help with!

Here's a snapshot of the tables and relationships. I've put the relevant
tables into this query layout just for illustrative purposes.

-----
click on it to make it bigger (it's still a little hard to read)

http://tinypic.com/view.php?pic=6xu9oh4&s=1

Note - the table names start with phrases that are not relevant to this
question (ie I use the word "record" for another use than the normal database
usage of that word).
------

I'll explain the setup. I want the Table Record-Orders-Sales to lookup
Record-CurrentDeals and only show the deals from a given System (a
geographical region), based on what Corp (a Corp is a subdivsion of each
System) is connected to this particular SalesOrder.

The Corp is not defined directly in the Record-Orders-Sales. Rather, the
Sales order is connected to a Customer-Account#(address) junction table. The
Account# table is related to the List of Corps(and the System it's in).

So here's the question. How can I get the Record-Orders-Sales table's
DealOrdered lookup to filter to only show a given System's deals? The Sales
order has a system associated with it, but distantly.

Any help would be greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code Check Request - Query to find reused values 2
Selected record as query criteria 2
How to Query on a forms custom recordsource? 7
Slow VBA-Generated SQL Involving Totals Query 9
filling a field using update query to add redundant data 2
Complex Autonumber Problem in a query 2
Problem with EXISTS clause in filter 2
Query based on 2 related tables 1

Top