Where are you inserting the value to client table ?

I have two tables; school and courses and need to insert records into the courses table that have the same school id as the corresponding record in the school table

And you have done what so far? We will help with errors etc, not doing homework. Please read our posting rules.

Also no information given, what language you are using, what tables in database etc.

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.