|
RE: how to add the country in the logbook column
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
Jordi, EA3GCV
Current developer of Swisslog
|