I need some Ideas on how to best handle or achieve and return the data which.
I have been trying to nut out a problem I have with Reps Customer Sales in another Reps Area.
Tables = Customer and Sales tried Join on CustomerNo and Suburbs but still not quite there
To give you a picture e.g.:
Rep number 102 has a Group of Customers, which have Office Addresses and the "Suburbs" of this Customers Group
set the Reps Area or Territory Boundary. from Customer Table
Now If any Sales Person makes a Sale into another Reps Customer Group into let say Rep 102 Area, "Suburb" he needs to be notified about this sale in his Area from another Customer. from Sales and Customer Table