I have a new client for the repossession business. It's a straight forward design, track all possible locations for a car. Could it be at the address listed on the contract, or at one on the credit app.

That individual might have 3+ addresses on file over time. I want to run a select statement that binds the most recent address transaction from the address file with the name and SSN of the individual.

I have a date in the address table. Should I go for a max( date) as the most recent address? Or are there other better methods?

Size of system will probably grow to 5000+ individuals, and 20,000 addresses, 50,000 contacts (friends and family off of credit apps).

TIA

__Stephen