Trying to get a link to child table

You need to add the html tags (<a href...) to make it clickable, then make sure it is set as view as html

Cheers.

I have it set as a QR Code, but I am struggling getting the masterkey1=$data["ID"]

It just shows the text and not getting the ID. I have something wrong with the masterkey1=$data["ID"] setup
Cheers

Try adding this right in your SQL Query:

I am using SQL Server.

Thnaks, but im on MySQL. I tried it anyway and it throws back an error with the convert in it.

Thanks anyway <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=82828&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

I am using SQL Server.

You should not be using PHP code in your SQL like $data["ID"]. You can use string values and field names there:

https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_concat

https://www.tutorialspoint.com/mysql/mysql-concat-function.htm
You should not include 'localhost' in the URL either, your solution will not be portable.

Cheers Sergey

Cant believe I was in fact trying too hard to get the ID and not just using ID!!!

The localhost is only for testing out, it will be replaced by the IP address once I get it working

Cheers