Here is part of my Base, where I define a simple Link to another Table.
However, I would also like to display only those linked names where a Checkbox has been set on the linked record.
How would I do that?
Graham
I have a Lookup which points to a Checkbox field on another table. The Lookup returns a ‘tick’ character for each of the records where a tick is present.
(The field called “Present” is the Checkbox. The ‘tick’ characters that are returned can be s...
I don’t need a separate table for each session, as I currently don’t take a historical (or future-planning) view - I just run the database at each session, marking the Checkbox accordingly. However, I might use a separate table in the future, so tha...
The database is about the activity of change ringing. It helps me to run a complex practice session for an ever-changing team of ringers, of mixed ability.
There are many interdependent activities we might attempt at a practice, each requiring a part...
Thanks @Kira_Lapin for that very clear explanation.
This is very neat.
It took me a while to get everything in the right place, but now it works perfectly.
While viewing Table A (below) I can produce an array of record names (from Table B) and a matching array of Checkbox values
Again, while viewing Table A, can I manipulate these arrays (using a formula) to produce a new, filtered array containing onl...