Hi there, silly question here:
I would like to retrieve a values from another table and here is my situation:
I have a subform with a combo box, that combo box is a list of the sales rep and also I have a textbox and it htat box I have: =[Sales Rep].[Colum][2] by doing this I can retrieve the region of each sales rep.
Now I have another table "Sales Rep Manager" in that table I have:
ManagerID
Region
Code
What I am trying to do is in the subform when I select a sales rep a field check what ids the region and brings the code that match that region.
Sorry, but I cannot figure this.
Any help will be very appreciated.
Regards,
I would like to retrieve a values from another table and here is my situation:
I have a subform with a combo box, that combo box is a list of the sales rep and also I have a textbox and it htat box I have: =[Sales Rep].[Colum][2] by doing this I can retrieve the region of each sales rep.
Now I have another table "Sales Rep Manager" in that table I have:
ManagerID
Region
Code
What I am trying to do is in the subform when I select a sales rep a field check what ids the region and brings the code that match that region.
Sorry, but I cannot figure this.
Any help will be very appreciated.
Regards,