JeanW, which two fields would you use in a self-join? I'm sorry to be dense, I just couldn't work out how that would help in this situation.
Jimb51, you listed a series of fields (Company/LastPayment, etc..) as your portal. You mean these are the fields you are displaying in the portal, right...