ID Name 2 Tom 3 Ron 4 Steve 5 Mike 6 Jon
Name Pos Dur Tom Cashier Old Ron Mngr Old Steve Stock New Tom Secur New Tom Mngr New
I am new to Access so forgive in advance if this is stupid basic or not even possible. Thank you in advance for any answers or suggestions. I am trying to create a form where my combo box would be based off of Name field in the upper table. The relationship between the two tables are joined by Name field as well. Once the value is selected in the Combo box, I would like values in the POS field from lower table to be added to a text box. However I want ALL values in the POS field to be added that correspond with the Name selected. So for instance, when Tom is selected in the combo box, I want Cashier, Secur and Mngr to auto populate in the text box. I would also like another text box to behave the same for the Dur field Old, New, New.