Help how to get values for Foreign Key in Android studio(SQLite)

[Android Question]

Actually i want to set primary key of login_table as foreign key in data_table but it gives me error of "foreign key violation". kindly guide me....

code is here::

 @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("create table " + TABLE_NAME + " (LID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT, AGE INTEGER,GENDER TEXT )");
        db.execSQL("create table " + TABLE_NAME1 + " (DID INTEGER PRIMARY KEY AUTOINCREMENT,HEIGHT INTEGER,WEIGHT INTEGER,RESULT INTEGER,DISPLAY DATETIME," +
                "DATA_ID INTEGER,FOREIGN KEY(DATA_ID) REFERENCES login_table(LID))");
        db.execSQL("create table " + TABLE_NAME2 + " (SID INTEGER PRIMARY KEY AUTOINCREMENT,SCHEDULE DATETIME)");

        db.execSQL("CREATE TRIGGER fk_data_login " + " AFTER INSERT "+ " ON "+TABLE_NAME1+ " FOR EACH ROW BEGIN"+
                " SELECT CASE WHEN ((SELECT "+COL_1+" FROM "+TABLE_NAME+" WHERE "+COL_1+"=new."+COLUMN_6+" ) IS NULL)"+ " THEN RAISE (ABORT,'Foreign Key Violation') END;"+ " END;");
}