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!
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!