Marla Posted October 20, 2016 Report Share Posted October 20, 2016 SELECT lastname, firstname FROM `tng_people` WHERE `private` = "1" ORDER BY lastname, firstname How can I add their ID List and TREE ID into this? Also I would like to click on their ID to open up. Thanks, Marla Quote Link to comment Share on other sites More sharing options...
jayat1familytree Posted October 21, 2016 Report Share Posted October 21, 2016 Marla, Just add those fields to the SELECT The TNG Report generator should automatically create a link anytime the ID field is requested. SELECT gedcom, personID, lastname, firstname FROM `tng_people` WHERE `private` = "1" ORDER BY lastname, firstname Quote Link to comment Share on other sites More sharing options...
Marla Posted October 22, 2016 Author Report Share Posted October 22, 2016 Thank you so much..... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.