how to link table to table

Question

I am a comsci student and I'm taking up database now. I got a problem in or should I say I dont know how to link table to table.

It is not like you'll just use a foreign key and connect it to the primary key. The outcome should be like this:

In the table Course there are three fields namely "course_id", "Description" and "subjects". When you click the name field Subject, a table named Subject should appear. Can you help me with this?

hope you understnd my grammar, hehe..im not good in english......it will be a big help if you can answer it.........thank you po..............

Answer 1

I dont think that you achieve this in database part, Here we need to code to get. Basically here the tables design should be prperly made with the parent-child relationship and Use any technology to implement.