Hello All,
So I have from frm22... with a listbox, when I select an option and click the "abrir" button, it opens up frm23... which has another listbox. this last listbox pulls data from a query filtered by the selection on the listbox of frm22.
Now, the query used pulls data from a relationship table, which is created from another two tables
The problem that I'm facing is the the listbox in frm23, instead of retrieving data as shown in the query (third column), it is showing the primary key, not of the query or the table used to create it, but the primary key of the original table (as you can see the numbers instead of names on the listbox of frm23) the filtering is done correct though, and the primary keys do correspond to the correct names, but I need to display the names... any suggestions?