Thank you guys for your kind replies! I have managed to solve the problem using a SELECT MAX(COUNT) to retrieve the last (which is the biggest in amount) key.
Thank you all for your valuable suggestions!
Hi,
May I know how do I go about getting the last value of the primary key that I get inserted? I need this PK to link the parent and child tables together.
Thanks for any valuable help!