I have been given what is effectively a flat-file database which needs converting to a relational database Ie the current (sole) table could look like this:
Ticket no description
123 original problem
123 a contact with user
123 the solution
124 a new problem
124 the solution
etc
What the user wants is to query this database to ONLY get the last record for each problem ticket?
Any ideas much apreciated
