Insert into 3 tables that are inter-dependent
===

I have 3 tables-

    1. Country (CountryName, CID (PK- AutoIncrement))
    2. State (SID(PK- AutoIncrement), StateName, CID (FK to Country)
    3. City (CityName, CID, SID (FK to State)

Now I need to insert only the name into the three tables with CountryName, StateName and CityName.. The IDs need to get updated. 

How'd I do this?

Thanks,

