Styjun

The situation is: I have one submit form with one input box and four checkboxes. I have two tables in a database.One table for input box records(called "reasons") and one table for checkbox records(called "reason_to_transaction"). When I click on submit button it checks if some of the checkboxes are checked and if the input box has some text and save the data from the input box and checkboxes into two different tables. Table "reasons" have two columns(id,name).Table "reasons_to_transaction" have two columns(reason id,transcation_type). The column from table(reasons_to_transaction) "transcation_type" save data from checkbox. The column from rable(reasons) save data from input box. How I can save data into the table("reaons_to_transaction") with id from table "reasons". My function now working but in "reason_id" is saving NULL. My code is:

How I can get last insert id in one table and save it into another table.
I'm using Angular Sequelize.

I have this code:

<form ng-submit="createReason(reasonsForm1.$valid)" name="reasonsForm1">
 <div class="row">
 <div class="col-sm-12">
 <div class="form-group">
 <label for="database_address">??? ?? ?????????:</label>
 <input type="text" class="form-control" ng-model="reasonname" placeholder="??? ????????? ?? ????????" />
 </div>
 <div class="container">
 <p>???????? ?? ???:</p>

 <ul>
 <li ng-repeat="album in albums">
 <input type="checkbox" ng-model="album.selected" value=album.name /> album.name
 </li>
 </ul>
 <button type='button' ng-click="save1()">Save</button><br>
 Saved results:<br>
 albumNameArray

 </div>


 </div>

 </div>
 <button class="btn btn-primary" type="submit">Save</button>
 <button class="btn btn-primary" id="cnlbtn1" type="button">Cancel</button>

 <!--ng-click="createUser()"-->
 <!--<button class="btn btn-primary" ng-disabled="userForm.$invalid" type="submit">???????? ?? ???</button>-->
</form>





$scope.createReason=function()
 {
 $scope.albumNameArray = [];
 angular.forEach($scope.albums, function(album)
 if (album.selected && album.name=="sell")
 
 defaultAdapter.query('INSERT INTO reason_to_transaction(transaction_type) VALUES("sell") ',

 
 /*replacements: objectToSave1,*/type:Sequelize.QueryTypes.UPDATE
 )
 $scope.refresh();
 
 var objectToSave = 
 name: $scope.reasonname,
 ;
 defaultAdapter.query('INSERT INTO reasons(name) VALUES(:name)',
 replacements: objectToSave, type: Sequelize.QueryTypes.UPDATE 
 ).then(projects => 
 console.log(projects);
 $scope.editMode = false;
 $scope.activeItem = false;
 $scope.refresh();
 );