We need to see more than the layout. What relationships etc do you have in place?
>We need to see more than the layout. What relationships etc do you have in place?
I can only post one screenshot per post - relationships screenshot posted in previous lengthy thread:
>Did you create qsoslabels 2 on the relationships tab or on the tables tab?
The relationships tab
>On the layout where you tried to set up the portal, what do you see in Layout Setup... | "Show Records From" ?
Every config / setting I can see is an exact clone of the previous file which did work correctly. It is beyond Mind Boggling ;-(
Per attached screenshot, the Sort Records in Preview Mode is the same (Callsign without the leading :: marks and all the relevent fields with :: at the beginning of the field names).
When I did a "Select All" on the label layout in Layout Mode, in the old file there seems to be *something* that is blank and can not figure out anyway to identify it (not a Portal). This is too weird.
All that needs to be done is to print ONE label PER CALLSIGN, regardless of how many field rows of "QSO" data are on it. I tried another Ham-Radio specific label program as a possible solution, but it will not accept my Date format of DD MM YYYY which FMP does.
I have posted a reponse to the other thread.
FYI, on the Sort Records Drop Down list, I also both the qsos2labels and qsos2labels 2 options, but got the same undesired multiple labels per Callsign results.
See your original thread where most of the needed info is already there. I've asked a key question about your layout. Your answer will likely review why you cannot select either table occurrence for your portal.
Do you want me to send you the file? It's only 124KB.
>See your original thread where most of the needed info is already there.
>I've asked a key question about your layout. Your answer will likely review
>why you cannot select either table occurrence for your portal.
Those issues were resolved after hours of fiddling, and the fields were selectable from qsos2labels 2 on the Portal Setup dialog/window.
Umh, the one salient thing I did remember about when the Tech Guru at FMP finally got things to work, was that a "Counter" field needed to be created, AND, placed ON the label form in Layout Mode. The Counter is functioning properly. I reset it several times before re-importing the small .csv data file, and double checked it. Actually, now that I recall, the original solution was done by FMP (via the Head of Customer Service) in 2006. Time sure flies, but did not have a need to use FMP again for labels until now. I also tried putting the Counter field in the Portal area and outside of it on the label (where it is now), but neither way worked. Baffling.
FYI, I also tried using Find and Omitting Duplicate (!) records with the same "Counter" serial number, and then Sorting those records. That did not work either. I seem to recall the FMP Tech Guru solution being an "Undocumented" fix.
On a layout based on qsos2labels you cannot place a portal to qsos2labels, only to table occurrences related to qsos2labels.
Clearly, you have at least one more table occurrence, named WIP, as this shows in one of your screen shots.
Here's a very simple way to get a table where there is only one record for each callsign value:
Take either the existing table and delete all records from it or create a new table with the same fields, go to Manage | Database | fields and double click the call sign field definition to open field options. Click the validation tab and specify "unique values" and "validate always".
Now import your data into this new, empty table. The validation rule will filter out records with duplicate call sign values so that you only get one record for each call sign.