if i have two tables(tblClient, tblAnswer) connected through a certain "ClientID" in my form. how do i code that the data that is input in my form will be save in both tables. i already know how to save on the first table(tblClient) which is plain INSERT statement. but i don't know how on saving in the second table on which the "ClientID"(PK-autonumber) on my tblClient will be save in my tblAnswer along with the other data. by the way, the first and second table have different data fields. the first one is on personal info on the client.