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.