i am having serious trouble with making relationships between tables using phpMyAdmin. I have used the Visual Builder to link the tables (using the primary key and linking it to an index).

I am using DreamWeaver to display the data but when I make the recordset and try run the page it says unidentified index and wont display the information.
See screenshot below


Any help is appreciated.
Thanks in advance,