Hi,
I've been trying to get this right for a while and I've just managed to get more frustrated.
I have 2 tables which I am trying to work with, basically I need to select a word from the wordtable and I want to filter the form by using the combobox and i want it to return a name from the nametable.
nametable has a unique identifier and a primary key but the second table does not have a primary key( i did not create the tables,i just have to work with them). I created a relationship between the 2 tables, the join type is one to many.
I have tried creating a combobox in the form header and also tried filtering by creating a combobox and a subform but I'm getting nowhere.
I've gone step by step following tutorials but I can't seem to adapt the information to my situation.
Thank you