View Record

[amsire2]

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.

[mobhar]

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