Hello All - Driving myself crazy with this.
3 tables: MAIN, ISSUES, NOTES.
MAIN table Fields: SSN, FirstName, LastName, Company
ISSUES table fields: SSN, Issue_ID, Issue_Type, Status, Date-Time
NOTES table Fields: Issue ID, Notes, Action, Date_Time
When the user looks up a SSN in MAIN_lis.asp it finds the record. Then they click on the ISSUES link from there and it lists all issues related by the Primary/Foriegn Key SSN. At the top of the page I have the MIAN table info still showing so that the user knows the persons LastName FirstName. So far so good.
Next the user can click on NOTES and they can see all the NOTES Records entered for that ISSUE. Unfortunate, once down to this level I can find no way or code that will let me show the records LastName and FirstName from the MAIN table.
Is this possible, or should I just move on?
THANKS YOU!