When I select the source in the course ID, the subjects of that course should appear. Then, the subjects I select should be shown. can you help

[moin555]

 

[moin555]

View attachment 119262

Matric subject name

Urdu

English

Mathematics

Islamiat

Pakistan Studies

General Science

Physics

Mathematics

Computer

 

[Pat Hartman]

You don't have a table that holds the subjects or the junction table CourseSubjects and where do you want the subject list to appear? You probably need a subform.

Here is a sample that shows how a many-many relationship works.

Many-to-many example

I added a new version on 1/16/23 so choose that one rather than the old one unless you specifically want the old one. The old zip file contains both A97 and AXP versions of the database. It uses venue booking as the example and shows the relationship from both sides. A venue main form with...

www.access-programmers.co.uk

 

[mike60smart]

Matric subject name

Urdu

English

Mathematics

Islamiat

Pakistan Studies

General Science

Physics

Mathematics

Computer

Can a person register for 1 Course only or do you want them to be able to register for 1 or More Courses??