You were reading my mind. Was going to create a detail page as you suggested.
The situation I am running into now is, there are 2 separate tables. One for Partners and one for Associates. The person who originally created the file created a joined table called "FullJoin" that merges both tables into a separate table. There is a column for a unique ID, APID is for Associates and column PPID is the unique ID for Partners. So if I was to have one page (details.asp for example), that would show the details from either the Associates or Partners table, how would I code it to whether it is APID or PPID?