report card issue

[daameta]

hello everyone
i am designing a database for prepare a progress card of students. i have a table "instituteinfo" which have school information which will be printed on every progress card. in this table only one row having data. and other is three table which have student data like name fathers name and class exam details. it also printed on progress card. all is well till. now i am trying to print instituteinfo data on every progress card which have only one record. there is a problem my progress card showing only one record. perhaps it related to relationship. i try all three method of relationship but till progress card show only one record.

 

[CJ_London]

you can only link data on relevant fields - so for example unless your student table has a field to indicate which school they belong to, you cannot link them.

If this is the case you have three options

1. remove the link from school table to whatever table it is linked to (you only have the one record so it will not result in duplicate records). This is called a Cartesian query.

2. alternatively remove the school table from the query and use dlookups in the form or report to display the data


3. remove the school table from the query and create it's own form or report to display just the school data which you can then use on your existing form/report as a subform/report

 

[stopher]

You can link the instituteinfo by doing a cartesian product. You do this by simply adding the table and field to your query but not creating a join. This will create a query with the instituteinfo field record against every record in your original query. You can choose to use the field like you would any other.

Alternatively you could use a Dlookup.

 

[daameta]

you can only link data on relevant fields - so for example unless your student table has a field to indicate which school they belong to, you cannot link them.

If this is the case you have three options

1. remove the link from school table to whatever table it is linked to (you only have the one record so it will not result in duplicate records). This is called a Cartesian query.

2. alternatively remove the school table from the query and use dlookups in the form or report to display the data


3. remove the school table from the query and create it's own form or report to display just the school data which you can then use on your existing form/report as a subform/report

Sir Can you give me a example of dlookups on report in my case.

 

[daameta]

You can link the instituteinfo by doing a cartesian product. Alternatively you could use a Dlookup.

Sir thanks for your reply can you give me more detail or example in me case about cartesian product or Dlookup. thanks