1 Topic by FMR (edited by FMR 2025-04-14 21:06:18)

  • FMR
  • Member
  • Offline
  • From: Earth Planet
  • Registered: 2022-01-02
  • Posts: 55

Topic: Print report from 2 table

Please fix my Project (Shopping List) contain 2 table (Header & Footer), How to print 2 linked table ?

Post's attachments

Attachment icon PrintTest.zip 336.8 kb, 19 downloads since 2025-04-14 

Life is like a school;
One can learn and graduate or stay behind.
  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,195

Re: Print report from 2 table

There are two tables in your database. But there is no connection (relationship) between them.
That is why you do not see anything in the report.


This page ( https://myvisualdatabase.com/database_examples.html ) contains examples of projects.
The project "Equipment inventory database" will help you study it.
This will help you establish relationships between the two tables and see the full result in the report and form tables.

  • FMR
  • Member
  • Offline
  • From: Earth Planet
  • Registered: 2022-01-02
  • Posts: 55

Re: Print report from 2 table

Dear sparrow

I do link the table in my attached project PrintTest.zip please see the screenshot :

https://i.ibb.co/qFxNxh6K/Link-Table.png

This is a correct link tables or not ?? please help

Life is like a school;
One can learn and graduate or stay behind.
  • From: Рідна МАТИ, UKRAINE
  • Registered: 2018-06-02
  • Posts: 1,195

Re: Print report from 2 table

It is not enough to create fields in tables, they need to be filled with values.
Your id_Footer field contains NULL information.

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,864

Re: Print report from 2 table

Hi Fmr, Hi Sparrow,
Your relationship is the wrong way round;  the relationship needs to be created on the ''footer'' table pointing back to the ''header'' table.
With very few exceptions, the relationship is always held on the table that contains one or more records that ''belong' to a single record in the other table
A simple example would be a database with two tables - ''customer'' and ''invoice''.   A customer can have many invoices but an invoice can only ever belong to a single customer (so the relationship is created on the ''invoice'' table linking it back to the ''customer'' table.
And so in your example, a ''header'' record can have many items in the ''footer'' table so the relationship is created in the 'footer'' table to link back to the ''header'' table.
Derek.