I wanted to make the primary field of a table into a link to another table. (Like using a foreign key as part of a primary key in a database.) Of course, I immediately discovered that was not allowed. So, I created a new field, made it a link, the...
I am creating a catalog of sheet music for some musical groups I play in. It has a main table with all the usual information to be expected (title, composer, arranger, etc.) plus some additional info, such as alias names and associated works or titl...
I have two fields in a table for a sheet music library: Last Name and Given Names.
Is there a formula expression that will produce the initials for the given names?
For example, If the Given Names field is just “Johann”, I would like to produce the s...
I figured that was why. And, it makes sense. But, then why not put quotes around every text string, uncondittionally? That would be a way to preserve the ability to create sorts on that field that continue to work. The way it worked for me was, t...
Thank you.
Yes, a filter is a way to accomplish this, but requires knowing about the structure of the table, and how to explicitly set up a Boolean expression. But, even that is only cursory, since the Boolean expression permitted by a filter is so ...
Thank you all, for your helpful responses.
Initially, before posting, I had considered Rebecca_Elam’s idea. However, I didn’t know how to deal with an unknown number of names (and I am just a private user creating my own personal sheet music library...
