newbe insert question

I want to insert a row in a table with a serial field. I also want to insert rows in other tables using that new serial number to relate them. How can I find out what the new number is ? Matt