Hey everyone,

I'm trying to put some values into this table:

create table Login
(
UserName varchar (16) primary key,
user_password varchar (16),
customerID char(10) not null,
foreign key (customerID) references Customer(customerID)
);

for example:

insert into Login values ( 'bobbybob', '123456', 'bob123456');

and it's giving me this error:

integrity constraint (SYS.SYS_C001956) violated - parent key not found

Does anyone know why?

Thanks in advance,
Joel