Member Avatar for dew97

in table department i've class_id as f.k and in class table class_id as p.k
i want to update class_id in department table..
n getting error

  • 3 Contributors
  • 2 Replies
  • 121 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for thines01

It should only give you an error in the "department" table if the F/K does not exist in the "class" table.

What is the error text you are receiving?

Also, what is the specific action you are doing in the department table?

Member Avatar for Reverend Jim

Can you please avoid convenient (for you) abbreviations? I assume f.k and p.k are foreign and primary keys. Also, some context would be nice. If you want help please do us the courtesy of providing as much information as you can. For example

1) how about some code for us to look at and a line number where the error occurs

2) how about an error number and description

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.