+- Swisslog's Forum (https://www.swisslogforwindows.com/forum)
+-- Forum: Swisslog version 5.x (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=3)
+--- Forum: General discussion (https://www.swisslogforwindows.com/forum/forumdisplay.php?fid=4)
+--- Thread: how to add the country in the logbook column (/showthread.php?tid=1286)
how to add the country in the logbook column - F6AUE - 29-08-2025
Hello,
I am trying to understand how to insert the country field of the contacted call into the logbook. I saw that the country field was in the Address table. How do I link this field to the QSO table in order to have it in the logbook?
Thank you for your help.
RE: how to add the country in the logbook column - EA3GCV - 29-08-2025
Hello,
The country name field is in the INF_DXCC table. You need to add the INF_DXCC table then join the DXCC field from the QSO table to the DXCC field of the INF_DXCC table. The join must be "Return all records from the QSO table and only matching records from the INF_DXCC table". Otherwise you won't see listed all QSOs with a blank DXCC (such as all /MM QSO). Then add the DXCC_NAME field from the INF_DXCC table to the query.
If you edit any of the queries included in the Queries\DXCC folder you will see an example of this link. IMPORTANT: in these queries the join is just the opposite! return all records from INF_DXCC and only matching from QSO.
73