各位前輩，我是新手:
這個問題找了一個禮拜，有買了3本書在學習
目前在練習會員系統

關於在INSERT INTO沒有外鍵的TABLE都正常
但是若是要新增資料到 有外鍵的 TABLE 都失敗
出現error:Cannot add or update a child row: a foreign key constraint fails

到底要怎麼才能成功新增資料，希望各位前輩能給個方向，非常感激!

TABLE HOTEL的Client_ID 跟 TABLE Client 的 Client_ID是關聯

create table hotel (
  id int unsigned not null auto_increment primary key
, hotel_id char(8) not null
, Client_id int unsigned not null 
, hotel char(8) not null
, room char(8) not null
, kind char(8) not null
, tablenum char(8) not null
, host char(8) not null
, foreign key (Client_ID) references actresses (id)
);

$hihotel=$_POST["hotel"];
$hiroom=$_POST["room"];
$hikind=$_POST["kind"];
$hitablenum=$_POST["tablenum"];
$hihost=$_POST["host"];

$insert_hotel_SQL = "INSERT INTO `hotel` (`hotel`, `room`, `kind`, `tablenum`, `host`) 
VALUES ('$hihotel','$hiroom','$hikind','$hitablenum','$hihost') 
WHERE Client_ID = $row['Client_ID']";

$selectSQL = "SELECT * FROM hotel";
$myData_hotel = $myconnect->query($insert_hotel_SQL);

if ($myData_hotel) {
    echo '新增成功';
    echo '流水號是' . $myconnect->insert_id;
} else {
    echo 'error' . $insert_hotel_SQL . '<br>' . $myconnect->error;
}