Hi, I'm struggling my #$@ off for 3 weeks now!! I have two tables: TrainingConducted and TrainingHistory which is related one-to-many through a TrCost_ID(Key).
That tables is represented in two forms - TrainingConducted and TrainingHistory. I want to populate a listbox with JUST the values where the TrCost_ID in TrainingConducted = TrCost_ID in TrainingHistory. Currently the listbox is filled with ALL the values in the TrainingHistory table.
Also,I want the Listbox to update in conjucntion with me moving through the records in the TrainingConducted table.