displaying records from other table.
I have two tables created.
Screenshots of tables are attached.
Now i have a artwork detail page where artwork tables field are shown. this page is created from dataaasist.
Now while viewing the artwork_details page it displays all data properly.
Im trying to show artist name linked with artist id in artwork table.
For this i m using Inner Join. i m not much familiar with this but somehow managed to get it done thru this: http://www.w3schools.com/sql/sql_join.asp
Now results are showing up on recordset while testing it. but all records are shwon.
Now i want to only show 1 record while filtering artist id of the open page.