relationship among tables!!..Plz help guyz

[GirishBreakTheRules]

Hello guyz,

am currently havin a problem with a report but i fink the main problem is with the relationship between my tables!. so i have built a scholarship system. I have details like school certificate,A levels result and degree information.

i have built a report which retrieves the school certificate results,A level and degree results for a particular candidate, you have to enter the id for a candidate to get the details.

But the fing i have notice is that all these 3 tables must contain records so that all the information is displayed, for example if a candidate is applying for an undergraduate degree for the first time, he'll obviously be having only school certificate and A levels results....The report doesnt display anyfing!!....But if for a particular candidate having all three records in the 3 tables, the report displays correctly!.

Is there an option for fixing the cardinality among tables so that even if a candidate doesnt have one among the three information, the report gets displayed??

Kind Regards!

 

[neileg]

The default join in Access is an inner join which only returns data if there is a match in both tables. If you right click on the join in your query, you can select a left or right outer join (type 2 or 3 in Access terms) which should fix your problem.

Having said that, it's almost certain that you should only have one table for all three types of qualification, not three.

 

[voidcranium]

The default join in Access is an inner join which only returns data if there is a match in both tables. If you right click on the join in your query, you can select a left or right outer join (type 2 or 3 in Access terms) which should fix your problem.

Having said that, it's almost certain that you should only have one table for all three types of qualification, not three.

THAT is probably the most clear example I have ever read on INNER JOINS.
Thank you.

 

[neileg]

THAT is probably the most clear example I have ever read on INNER JOINS.
Thank you.

Happy to help