You don't actually need to copy your data into a separate table for this as far as I can tell from a single post, but to answer your question:
The table must be related, but you can use the X operator in this relationship.
In Layout Setup for each layout where you want to add this list, there's a table occurrence listed in "Show Records From" this is a "box" in Manage | Database | Relationships. For each layout where you want this list, link it's table occurrence to this table with this type of relationship:
LayoutTable::anyfield X HallofFameTable::anyField
The X operator matches any record in LayoutTable to all records in HallofFameTable so this produces the list you want so that you can place it in the footer.
That was easy!
What was your other solution? Just for my personal instructional curiosity ;-)
If you have time of course!
Hard to say without knowing more about your database, but presumably this data is already in another table. If you match to it with this same x operator and use a portal filter expression to isolate the records designated as your "hall of fame" you wouldn't necessarily need to copy the data into a dedicated table.
On the other hand, this approach may slow down how fast your screen updates so if you decide to try this, test it carefully to make sure that it works smoothly for you.
I have a tricky question on the sidelines:
How do I sort records in ascending order when some of the records are blank? I would like the lowest "not blank" record to appear first in the table. I've tried with the constrain records instruction but to no avail
Might be missing something...
Sort or find? "Constrain" isn't a sorting option.
To exclude records when a field is blank, you can put the * operator in it while in find mode.
No, this is really a sort I need
I have my list of players that I need complete (all 18 of them)
If I do a descending sort on whatever parameter, obviously the highest value appears first.
On the other hand if I do an ascending sort, the records with no values yet appear first and then those with values at the bottom of the list.
I'll attach a screen capture of my layout so you see what I mean
It concernes the stats average "round" column. The first figure at the top should be 78, then 84 then 100, and all the blank values after
got it; was trying to upload a pdf... RTFN as they say...;-)
Did you use the newly added set of "upload an image" controls below this Post A Answer box?
Empty fields will sort before fields that contain data. That's expected Filemaker behavior as the empty fields evaluate as less than a field with data.
If you need to see the records with empty fields listed at the end of the list, you'd need to do something a bit sneaky.
Define a calculation field as:
If ( IsEmpty ( YourField ) ; "zzzzzzzzzzzzzzzzzzzzz" // if your field is text or 9999999999999999 if it is a number ; YourField )
Clear the "do not evaluate if all referenced fields are empty" check box and then sort on this field instead of the original field. (Make sure the return type of this field is the same as YourField.)
elegant and simple!
works like a charm!