That solution only partly solves the problem, I can user session variables to enter the username and unique ID, but since 'user2' is updating their page it is not possible to enter user1's name, and since user1 is the one subscribing then there is no data to filter the results using their current session variable. The record looks like
2 - user2 - NA - 1/4/2010 - 6
Is their anyway to filter it by the userID number showing the last date but only return results filtered by the current session variable of the user logged on (the subscriber) so for example... if I had user1 subscribing to user2 and these two rows exist in the table.
1. user2 - user1 - 1/3/2010 - 6
2. user2 - NA - 1/4/2010 - 6
when user1 is logged on with a session variable equaling their username I need to filter by username= user1
the results I am looking for would be , user2 1/4/2010