www.hkvforums.com

hi

I have to tables

Table 1 = Visit
fields = VisitID, Date, Time, Category, PatientID

Table 2 = Patient
fields = PatientID, PatientName, Address, ContactNum

My question is, how can I display full record of patient when I click the PatientID in Table 1. I try use hyperlink at the PatientID in Table 1 but no record found.

You may post your code that displays the link for more discussion.